17.10 - Required Attributes - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

Product
Parallel Transporter
Release Number
17.10
Release Date
June 2021
Content Type
Programming Reference
Publication ID
B035-2516-061K
Language
English (United States)
Export Driver Required Attributes 
Attribute and Type Type Description
TD_BUFFER_MODE varchar Indicates which type of export method is used.
Valid values are:
TD_INSTANCE_NUM integer Specifies the instance number of the current instance.
  • If the current instance is the main instance, then the instance number is one.
  • If the current instance is a worker instance, then the instance number will be a value greater than one.
TD_LOGSQL varchar Directs the Export driver to output the full Teradata SQL request in the trace output file with the driver’s trace is enabled. By default, when the driver’s trace is enabled, the Export driver outputs the Teradata SQL request, up to 32 kilobytes, in the trace output file.
Valid values:
  • Yes ('Y') = Output the full Teradata SQL in the trace output file when the driver’s trace is enabled. The maximum length of the Teradata SQL is 1 megabyte.
  • No ('N') = Do not output the Teradata SQL in the trace output file.
When the driver’s trace is disabled, TD_LOGSQL has no effect.
TD_MAX_INSTANCES integer Specifies the total number of instances (main and workers). Required only when using multiple instances of the same driver in a main-worker environment.
TD_RESTARTMODE integer Required only before restarting and must be set to one.
TD_SELECT_STMT varchar Specifies a Teradata SQL SELECT statement or statements.

See Teradata SQL reference documentation for your operating system, and enter one or more valid Teradata SQL SELECT statements for this SelectStmt attribute.

Each statement or group of statements must be enclosed in single quotes and must be terminated with a semicolon. Multiple statements cannot be added using the AddArray Attribute function. If you have multiple SQL SELECT statements, put them together in a single string with semicolons separating the statements and use this string as the value in the Add Attribute function.

TD_SYSTEM_OPERATOR varchar Specifies the type of driver being used (in this case TD_EXPORT).
TD_USER_NAME varchar Provides the user name for the Export driver logon sessions.
TD_USER_PASSWORD varchar Specifies the password associated with the user name.