17.00 - Required Attributes - Parallel Transporter

Teradata® Parallel Transporter Application Programming Interface Programmer Guide

prodname
Parallel Transporter
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2516-220K
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 master instance, then the instance number should be one. Required only when using multiple instances of the same driver in a master-slave environment.

If the current instance is a slave instance, then the instance number should 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 (master and slaves). Required only when using multiple instances of the same driver in a master-slave 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.