where the following is true:
- charpos1 and charpos2
- Start and end character positions of a field in each input record that contain extraneous information
- For example:
- Use charpos1 to ignore only the single specified character.
- Use charpos1 THRU to ignore all characters from charpos1 through the end of the record.
- Use THRU charpos2 to ignore all characters from the beginning of the record through charpos2.
- Use charpos1 THRU charpos2 to ignore all characters from charpos1 through charpos2.
- env_var
- Environment variable that provides the value for the specified utility variables (var)
- fileid
- Data source of the external system
- The external system DD (or similar) statement specifies a file.
- In z/OS, this is a DDNAME. (See Usage Notes.)
- In UNIX OS and Windows, this is the path name for a file.
If the path name contains embedded white space characters, the entire path name must be enclosed in single or double quotes.
If the path name is enclosed by single quotes and there is an embedded single quote, then an escape character needs to precede the embedded single quote. Likewise, if the path name is enclosed by double quotes and there is an embedded double quote, then an escape character needs to precede the embedded double quote.
If the path name contains single or double quotation marks, it should be enclosed in either single or double quotation marks.
- var
- Name of the Teradata MultiLoad variable that is to be set with the value accepted from the designated source
- Character string values appear as quoted strings in the data file.