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)
Category: Bulk Loading
Default: driver_name timestamp
Restriction: This option is valid only when using the TPT API.
Requirement: To use this option, you must first specify TPT=YES.
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, TPT_PACKMAXIMUM= data set option

Table of Contents

Syntax

TPT_TRACE_OUTPUT=file-name

Syntax Description

file-name

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

Details

Note: Starting in SAS 9.4M9, FastLoad and MultiLoad are no longer supported. Documentation remains for users who have not upgraded to SAS 9.4M9.

You can save diagnostic messages to an external log file when loading data to Teradata using the TPT API. If you request tracing but specify no name in TPT_TRACE_OUTPUT= for the log file, 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. If the file already exists, it is overwritten. See your Teradata documentation for details.

Last updated: February 3, 2026