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. |