Data Set Options for Relational Databases |
Default value: | 1 |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS support: | Teradata |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
TPT_TRACE_LEVEL=integer |
specifies the needed tracing level (1 to 9) when loading data to Teradata.
1 |
no tracing |
2 |
operator-level general trace |
3 |
operator-level command-line interface (CLI) trace |
4 |
operator-level notify method trace |
5 |
operator-level common library trace |
6 |
all operator-level traces |
7 |
Telnet API (TELAPI) layer general trace |
8 |
PutRow/GetRow trace |
9 |
operator log message information |
Details |
To use this option, you must first set TPT=YES. This option is valid only when using the TPT API.
You can perform debugging by writing diagnostic messages to an external log file when loading data to Teradata using the TPT API. If you do not specify a name in TPT_TRACE_OUTPUT= for the log file, a default name is generated using the current timestamp. See your Teradata documentation for details.
See Also |
Maximizing Teradata Load Performance
TPT_TRACE_LEVEL_INF= Data Set Option
TPT_TRACE_OUTPUT= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.