15.10 - Required Attributes - Parallel Transporter

Teradata Parallel Transporter Application Programming Interface

prodname
Parallel Transporter
vrm_release
15.10
category
Programming Reference
featnum
B035-2516-035K

Required Attributes

 

Table 27: Export Driver Required Attributes 

Attribute and Type

Type

Description

TD_BUFFER_MODE

varchar

Indicates which type of export method is used.

Valid values are:

  • No (‘N’) = Exporting will be on a row by row basis. This is the default value.
  • Yes (‘Y’) = The GetBuffer feature will be used to export. For more information, see “Export Data from a Teradata Database using GetBuffer” on page 30.
  • 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.
  •  
  • Note: 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.