Data Set Options for Relational Databases |
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.
Default value: |
driver_name timestamp
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Teradata
|
- 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, then a default name is generated using the
name of the driver and a timestamp. If a name is specified using TPT_TRACE_OUTPUT,
then that file will be 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.
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
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.