Teradata FastLoad Configuration File
A Teradata FastLoad configuration file can be created to set the initial default values for the following operating parameters when Teradata FastLoad is invoked:
Note: RETRYFIRSTCONNECT, RETRYOTHERCONNECT and RETRYCONNECTINTERVAL can only be specified in the configuration file for network-attached platforms, there are no corresponding command line options.
The values specified in the Teradata FastLoad configuration file override the internal utility default values for these parameters.
The configuration file parameters themselves can be overridden by the TENACITY, SLEEP, SESSION, and SET SESSION CHARSET commands in the Teradata FastLoad job script, and by the corresponding runtime parameters, as shown in Table 8 on page 36 and Table 9 on page 38. The order of preferences for the TENACITY, SLEEP and SESSION specifications, from the highest to lowest, is:
1 Runtime parameters
2 Teradata FastLoad script commands
3 Teradata FastLoad configuration file specifications
4 Teradata FastLoad default values
Note: The utility default for TENACITY is no tenacity. Either a configuration file entry, the runtime parameter, or the TENACITY command in your Teradata FastLoad job script must be used to enable the tenacity feature for the Teradata FastLoad logon operation.
The order of preferences for the CHARSET specification, from the highest to lowest, is:
1 Runtime parameters
2 Teradata FastLoad script commands
3 Teradata FastLoad configuration file specifications
4 Teradata FastLoad default values
Configuration File Name and Location
On network‑attached systems, the Teradata FastLoad configuration file must be named:
floadcfg.dat
And it must be located in either:
On mainframe‑attached systems, the DD statement for the Teradata FastLoad configuration file must be labeled FLOADCFG
Configuration File Contents
The Teradata FastLoad configuration file can have up to twelve entries, one for each parameter:
TENACITY=hours
SLEEP=minutes
BUFSIZE=kilobytes
CHARSET=character‑set‑name
INMODRETURN=ON or YES
MAXSESS=max‑sessions
MINSESS=min‑sessions
DATAENCRYPTION=ON or OFF
CONFIGERRORS=IGNORE/TERMINATE
RETRYFIRSTCONNECT=n
RETRYOTHERCONNECT=n
RETRYCONNECTINTERVAL=s
where:
INMOD return codes will be checked
displays. Nonzero return codes force Teradata FastLoad to terminate.
The configuration file can also have comment statements preceded by a number sign (#) character.
Configuration File Processing
Teradata FastLoad automatically checks for a configuration file each time the invocation command is entered. Upon locating a configuration file, the utility sets the defaults as specified, produces the appropriate output messages, and begins processing the Teradata FastLoad job.
By default, any invalid configuration file entry or syntax error immediately aborts a job and produces return code 12. The first invalid parameter is reported; none of the other configuration parameters are checked.
The CONFIGERRORS value can be changed more than once in a configuration file. Its value affects subsequent entries processing until the next CONFIGERRORS entry or until the end of the configuration file.
If no configuration file exists, the utility begins processing the load job without an error indication. The configuration file is an optional feature; its absence is not considered an error condition.
Note: The config file must be in the platform‑appropriate single‑byte character set, like ASCII or EBCDIC.