where the following is true:
- FORMATTED
- Keyword specification that the input data source is in Teradata Database standard format.
- UNFORMATTED
- Keyword specification that the input data source deviates from Teradata Database standard format.
- BINARY
- Keyword specification that the input data source is in binary format.
- TEXT
- Keyword specification that the input data source is in text format.
- VARTEXT
- Keyword specification that the input data source is in variable-length text record format, with each field separated by a delimiter character.
- 'c'
- Optional specification of the delimiter that separates fields in the variable-length text records of the input data source
- DISPLAY_ERRORS
- Optional keyword specification that writes input data records that produce errors to the standard error file.
- 'efilename'
- Optional specification of a regular file name used to store erroneous variable-length text records. If it's specified, it must be specified after the DISPLAY_ERRORS keyword.
- NOSTOP
- Optional keyword specification that inhibits the Teradata FastLoad termination in response to an error condition associated with a variable-length text record.
- TRIM
- Optional keyword. It is used to specify whether field values in variable-length text record could be trimmed. It must be followed by one of the following keywords: NONE, LEADING, TRAILING or BOTH.
- NONE
- Can follow the keyword TRIM. It is used to specify that field values are not to be trimmed. TRIM NONE is the default behavior of the trim processing, which is the same as not specifying the TRIM at all.
- LEADING
- Can follow the keyword TRIM. It is used to specify the leading characters of field values must be trimmed. See 'p' below for trim character specification.
- TRAILING
- Can follow keyword TRIM. It is used to specify that the trailing characters of field values must be trimmed. See 'p' below for trim character specification.
- BOTH
- Can follow keyword TRIM. It is used to specify that the leading and trailing characters of field values must be trimmed. See 'p' below for trim character specification.
- 'p'
- Optional specification of the trim character in field values of variable-length text records of the input data source. It is specified after the keyword LEADING, TRAILING or BOTH.
- QUOTE
- Optional keyword. It is used to specify whether field values in variable-length text record will never be quoted (if it is followed by keyword NO), optionally be quoted (if it is followed by keyword OPTIONAL) or always be quoted (if it is followed by keyword YES). It must be followed by one of the following keywords: NO, OPTIONAL or YES.
- NO
- Can follow keyword QUOTE. It is used to specify that field values will never be quoted. It is the default behavior.
- OPTIONAL
- Can follow keyword QUOTE. It is used to specify that field values will optionally be quoted.
- YES
- Can follow keyword QUOTE. It is used to specify that field values will always be quoted.
- 'q'
- Optional specification of the opening quoted character in field values of variable-length text records of the input data source. See 'r' for more information.
- 'r'
- Optional specification of the closing quoted character in field values of variable-length text records of the input data source.