SET SESSION FUNCTION TRACE Syntax Elements - Teradata Vantage - Analytics Database
SQL Data Definition Language Syntax and Examples
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2025-11-22
- dita:mapPath
- jco1628111346878.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- mdr1472255012272
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- trace_enabling_specification
- Output tracing is enabled for all user-defined functions or external SQL procedures the current user performs in subsequent DML requests in the current session.
- The UDF trace output is written to the materialized global temporary trace table defined by table_name.
- See CREATE USER for more information about defining default character data types for users.
- mask_string
- An arbitrary character string to be interpreted by any UDF performed in the current session.
- An arbitrary character string to be interpreted by any UDF performed by the current session.
- The string is limited to 256 logical characters in the character set defined for the user. This means, for example, that the string has a maximum length of 256 bytes if the UDF was created under a Latin character data type, but has a maximum length of 512 bytes if created under a Unicode character data type.
- UDFs convert this string to the default character data type in effect when the function was created, not the default character data type defined for the user for the session.
- All necessary conversions are done by the system. If, for example, a UDF was created with Unicode, but is called by a user with a session character set of Latin, the trace string is translated to Latin before it is passed to the UDF. If a pre-conversion trace string contains characters that have no equivalent in the target character set, the system returns an error. See SQL External Routine Programming for more information.
- database_name
- Name of the containing database or user for table_name.
- The database name is only required when the table is contained in a database other than the current default database for the session.
- table_name
- Name of a global temporary trace table into which function trace data is to be written.
- See the SET SESSION FUNCTION TRACE “Function Trace Output Table” topic in Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184 and CREATE GLOBAL TEMPORARY TRACE TABLE for further information.
- OFF
- Currently active UDF tracing is disabled for the current user in the current session, so the option to output anything for a function is turned off.