16.20 - FNC_Trace_String - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Purpose

Returns the current setting of the UDF, UDM, or external stored procedure trace string set up with the SET SESSION FUNCTION TRACE statement.

Syntax

void
FNC_Trace_String ( void  *TraceStr )
void *TraceStr
a pointer to memory that can hold the trace string.

Argument

The trace string is in the default character set of the user at the time the function was created or replaced.

The string is zero terminated. For UNICODE, the terminator is 16 bits of zero.

If the trace option is off, the string is set to NULL.

Example Using FNC_Trace_String

SQL_TEXT TraceStr[258];

...

 FNC_Trace_String(TraceStr);

Related Topics

For more information on SET SESSION FUNCTION TRACE, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.