Syntax - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
qja1608578437326.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities


where the following is true:

charpos1 and charpos2
Start and end character positions of a field in each input record that contains 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, the fileidis a DDNAME. (See Usage Notes.)
  • In UNIX OS and Windows, fileid is the path name for a file. If the path name has embedded white space characters, enclose the entire path name in single or double quotation marks.
  • If the path name is enclosed by single quotation marks and there is an embedded single quotation mark, then an escape character (single quotation mark) needs to precede the embedded single quotation mark. Likewise, if the path name is enclosed by double quotation marks and there is an embedded double quotation mark, then an escape character (double quotation mark) needs to precede the embedded double quotation mark.

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