SET SESSION FUNCTION TRACE Syntax Elements - Teradata VantageCloud Lake

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.; 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.; The system does all necessary conversions. For example, if a user with a session character set of Latin calls a UDF created with Unicode, the system translates the trace string to Latin before passing it to the UDF. If a pre-conversion trace string contains a character with no equivalent in the target character set, the system returns an error.
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 SET SESSION FUNCTION TRACE Usage Notes and CREATE GLOBAL TEMPORARY TRACE TABLE for further information.

OFF

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.