The IMPORT command syntax depends on whether the FastExport utility is running on a mainframe-attached or workstation-attached client system. Several of the syntax elements are common to both configurations, while others are specific to each.
where the following is true:
- INFILE fileid
- Input file on the client system
- AXSMOD name
- Name of the access module file to be used to import data. These access modules include:
- Teradata Access Module for OLE DB: oledb_axsmod.dll on Windows platforms
Teradata Access Module for JMS (libjmsam.so on AIX, Linux, and libjmsam.dll on Windows platforms).
- init-string
- Optional initialization string for the access module
- INMOD modulename
- Optional user-written routine for preprocessing the input data
- USING (parms)
- Character string containing parameters can be passed to the INMOD routine:
- The parms string can include one or more character strings, each delimited on either end by either an apostrophe or a quotation mark
- The maximum size of the parms string is 1K bytes
- Parentheses within delimited character strings have the same syntactical significance as alphabetic characters
- Before passing the parms string to the INMOD routine, FastExport replaces the following with a single blank character:
- Each comment
- Each consecutive sequence of white space characters, such as blank, tab, and so on, that appears outside of delimited strings
- The entire parms string must be enclosed in parentheses and, on mainframe-attached client systems, the parentheses are included in the string passed to the INMOD routine
The parms string must be FDLINMOD for INMOD routines written for the prior Pascal version of FastLoad (program FASTMAIN). - FORMAT…
- Record format of the input file, where:
- ‘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
- NOSTOP
- [Optional] Keyword specification that inhibits the FastExport termination in response to an error condition associated with a variable-length text record
- LAYOUT layoutname
- Identifier of the file layout description, as specified by a prior LAYOUT command
- EFILE <efilename>
- Optional keyword specification that writes input data records that produce errors to the user specified error file. If the user does not specify the error file name, the default error destination is the standard error file for workstation-attached platforms, and the SYSOUT for mainframe-attached platforms.
- 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 specified 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' 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' 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' 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.