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 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 database. |
| -a AccountId | Account id of the logon account. |
| -b DatabaseName | Database name for the error table. If the database name is specified, the twbertbl tool prepends 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 characters 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. |
| --LogonMech LogonMechanismName | Specifies which logon mechanism to use. The job terminates if the value exceeds 8 bytes. For information on specification requirements for LogonMech, see “Logon Security” in Teradata® Parallel Transporter User Guide, B035-2445. |
| --LogonMechData "Logon Mechanism Data" | Specifies additional logon data for external authentication. The logon mechanism data is case-insensitive. Specification of this option is required for some external authentication methods. For information on specification requirements for LogonMechData, see "Logon Security" in Teradata® Parallel Transporter User Guide, B035-2445. |
| --ConnectString "connectionString" | Specifies the connection string. The connection string will be passed to CLI. CLI will validate the connection string. For information on connection string, see Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418. The TPT Connection String feature is available on all platforms, except z/OS.
|
| --DataEncryption On | Off | Enables full encryption of SQL requests, responses and data. Valid values are:
This option does not include logon encryption.
|