TPT_TRACE_OUTPUT= Data Set Option

Specifies the name of the external file for SAS to use for tracing when using the TPT API with Fastload, MultiLoad, or Multi-Statement insert.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	driver_name timestamp
Data source:	Teradata
See:	Maximizing Teradata Load Performance , Using the TPT API , BULKLOAD= LIBNAME option, BULKLOAD= data set option, MULTILOAD= data set option , MULTISTMT= data set option, TPT= LIBNAME option, TPT= data set option, TPT_TRACE_LEVEL= data set option, TPT_TRACE_LEVEL_INF= data set option

Syntax

Details

Syntax

TPT_TRACE_OUTPUT=integer

Syntax Description

integer: specifies the name of the external file to use for tracing. The name must be a valid filename for the operating system.

Details

To use this option, you must first set TPT=YES. This option is valid only when using the TPT API.

When loading data to Teradata using Teradata PT API, diagnostic messages can be written to an external log file. If no name is specified for the log file and tracing is requested, a default name is generated using the name of the driver and a timestamp. If a name is specified using TPT_TRACE_OUTPUT, that file is used for trace messages. If the file already exists, it is overwritten. Please refer to the Teradata documentation for more details.

You can write diagnostic message to an external log file when loading data to Teradata using the TPT PT API. If you do not specify a name in TPT_TRACE_OUTPUT= for the log file and tracing is requested, a default name is generated using the name of the driver and the current timestamp. Otherwise, the name that you specify is used for tracing messages. See your Teradata documentation for details.