- AMPCHECK
- BRIEF
- CALLINMODFORFINALCKP
- CHARSET
- CONFIGERRORS
- DATAENCRYPTION=ON or OFF
- ERRLOG
- IFORMAT
- OFORMAT
- MATCHLEN
- MAXSESS
- MINSESS
- RETRYCONNECTINTERVAL
- RETRYFIRSTCONNECT
- RETRYOTHERCONNECT
The values specified in the Teradata MultiLoad configuration file override the internal utility default values for these parameters.
- 1 – Run-time parameters
- 2 – Teradata MultiLoad script
- 3 – Teradata MultiLoad configuration file specifications
- 4 – Teradata MultiLoad default values
Configuration File Name and Location
- The directory from which Teradata MultiLoad was launched
or
- The directory specified in the MLOADLIB environment variable
On mainframe-attached systems, the DD statement for the Teradata MultiLoad configuration file must be labeled MLOADCFG.
Configuration File Contents
The Teradata MultiLoad configuration file can have up to eleven entries, one for each parameter:
- AMPCHECK = none/all/apply
- none/all/apply for AMPCHECK configures the Teradata MultiLoad response to a down AMP condition, see Dealing with AMPS and BEGIN MLOAD and BEGIN DELETE MLOAD for more information.
- BRIEF = on/off
- on/off for BRIEF configures the reduced print output specification for the Teradata MultiLoad job.
- CALLINMODFORFINALCKP = Y[es]/N[o]
- This parameter calls INMOD for a final checkpoint of the Teradata MultiLoad job. Y[es] calls inmod for the final checkpoint. N[o] (default) prohibits MultiLoad from calling the final checkpoint with INMOD.
- CHARSET=character-set-name
- character-set-name is the character set specification for the Teradata MultiLoad job.
- CONFIGERRORS=IGNORE/TERMINATE
- IGNORE/TERMINATE configures the option for the Teradata MultiLoad configuration file error handling.
- DATAENCRYPTION=on/off
- on/off for DATAENCRYPTION specifies whether data encryption will be enabled for the Teradata MultiLoad job.
- ERRLOG=filename
- filename is the alternate file specification for Teradata MultiLoad error messages.
- IFORMAT = scriptencoding
- scriptencoding for IFORMAT is the character set specification for the job script file. This parameter can be used on workstation-attached systems only.
- Valid values for UTF-16 are UTF16 and UTF-16
- Valid values for UTF-16BE are UTF-16BE, UTF16-BE and UTF16BE
- Valid values for UTF-16LE are UTF-16LE, UTF16-LE, and UTF16LE
- When UTF-16 BOM is present and 'UTF-16' is specified, Teradata MultiLoad interprets the script according to the endianness indicated by the UTF-16 BOM. When the UTF-16 BOM is not present, Teradata MultiLoad interprets the script according to the endianness indicated by the encoding option.
- OFORMAT = outputencoding
- outputencoding for OFORMAT is the character set specification for the screen output. This parameter can be used on workstation-attached systems only.
- Valid values for UTF-16 are UTF16 and UTF-16
- Valid values for UTF-16BE are UTF-16BE, UTF16-BE and UTF16BE
- Valid values for UTF-16LE are UTF-16LE, UTF16-LE, and UTF16LE
- MATCHLEN=on/off
- on/off for MATCHLEN configures the record length validation option for the Teradata MultiLoad job. When MATCHLEN is enabled, Teradata MultiLoad verifies that the record length of the import data is the same as the layout record length specified by the IMPORT command.
- MAXSESS=max-sessions
- max-sessions is the MAXSESS specification for the maximum number of Teradata MultiLoad sessions logged on to the database.
- MINSESS=min-sessions
- min-sessions is the MINSESS specification for the minimum number of Teradata MultiLoad sessions required to run the job.
- RETRYCONNECTINTERVAL=s
- s specified for RETRYCONNECTINTERVAL is the interval in seconds between retries. The default value is 60.
- RETRYFIRSTCONNECT=n
- n specified for RETRYFIRSTCONNECT is the maximum number of connection retries when MultiLoad attempts to connect to the database the first time to SQL main session and it receives the CLI 207 error returned. The default value is 0.
- RETRYOTHERCONNECT=n
- n specified for RETRYOTHERCONNECT is the maximum number of connection retries when MultiLoad attempts to connect to the database the other connections and it receives the CLI 207 error returned. The default value is 16.
The Teradata MultiLoad configuration file can also have comment statements preceded by a number sign (#) character. For detailed descriptions of the specifications listed here, see Runtime Parameters.
Configuration File Processing
The utility 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 job.
- If CONFIGERRORS=IGNORE is specified in the config file, any subsequent config file problems will be reported but not affect the Mload return code. Mload will continue to process the next entry in the config file utility.
- If CONFIGERRORS=TERMINATE is specified in the config file, any subsequent invalid configuration file entry will abort the Teradata MultiLoad job.