16.10 - Syntax - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)


where:

Syntax Element Description
-u UserName User name of the Teradata logon account.
-p Password Password of the Teradata logon account.

If omitted, the twbertbl tool will prompt you for the password on non-z/OS platforms.

If omitted, the twbertbl tool will terminate with an error on z/OS platforms.

The password is case sensitive

-t ErrorTableName Name of the error table.

The error table name can be fully qualified.

-n NumberOfLoadedColumns Number of columns sent to the Teradata Database in the original load job.

The -n option is required for the DELIMITED and TEXT record formats.

The -n option is not required for the BINARY, FORMATTED, and UNFORMATTED record formats.

-h TdpId TdpId of the Teradata Database.
-a AccountId Account id of the Teradata logon account.
-b DatabaseName Database name for the error table.

If the database name is specified, the twbertbl tool will prepend the database name to the error table name.

-c ClientSessionCharSet Client session character set.

The default is 'ASCII' on non-z/OS platforms.

The default is 'EBCDIC' on z/OS platforms.

-o OutputFileName Name of the output file that stores the error table information.

The default is <ErrorTableName>.txt.

The output file name is case sensitive.

-m MaxNumberOfRowsToProcess Maximum number of rows to write to the output file.

The default is unlimited.

-d DelimiterCharacter Single-byte or multi-byte characters delimiter used to separate fields in the output file.

The default is the pipe character '|'.

The delimiter character(s) is(are) case sensitive.

The -d option is applicable when the record format is DELIMITED.

The -d option is not applicable when the record format is BINARY, FORMATTED, TEXT, or UNFORMATTED.

-q QuotedFields Option to quote the fields in the output file.

Value can be 'Y' or 'N'.

The default is 'N'.

If the value is 'Y', all fields will be quoted.

The -q option is applicable when the record format is DELIMITED.

The -q option is not applicable when the record format is BINARY, FORMATTED, TEXT, or UNFORMATTED.

-e EndiannessOfLoadJob Endianness of the error data in the error table.

Value can be 'BE' or 'LE'.

'BE' means big-endian.

'LE' means little-endian.

If omitted, the twbertbl tool will attempt to determine the endianness of the error data in the error table.

-r RecordFormat Record format of the error data in the error table.

Value can be 'DELIMITED', 'BINARY', 'FORMATTED', 'TEXT', or 'UNFORMATTED.

The default is 'DELIMITED'.

-x TraceFile Name of the trace file for the twbertbl tool.

By default, trace is off.

The trace file name is case sensitive.

All values for the options are case insensitive unless otherwise specified.