Syntax - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
16.20
Published
September 2020
Language
English (United States)
Last Update
2020-09-11
dita:mapPath
lki1527114222329.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities


where the following is true:

fileid
Data source of the external system
The external system DD (or similar) statement specifies a file:
  • In UNIX OS and Windows, the 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 quotes.

    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.

  • In z/OS, the fileid is a DDNAME.
IGNORE charpos1 and charpos2
Start and end character positions of a field in each input record that contains extraneous information. If one of the following is specified:
  • charpos1, then FastExport ignores only the single specified character
  • charpos1 THRU, then FastExport ignores all characters from charpos1 through the end of the record
  • THRU charpos2, then FastExport ignores all characters from the beginning of the record through charpos2
  • charpos1 THRU charpos2, then FastExport ignores all characters from charpos1 through charpos2