Use the attribute definition list syntax in the Teradata PT DEFINE OPERATOR statement to declare the required and optional attribute values for the MultiLoad INMOD Adapter operator.
|IndicatorMode = 'option'||Optional
attribute that specifies whether indicator byte(s)
is included at the beginning of each record (when
the MultiLoad INMOD Adapter operator is used as a
When the MultiLoad INMOD Adapter operator is used as a filter-type operator, this is the optional attribute that specifies whether the MultiLoad routine can handle indicator byte(s).
|InmodName = 'moduleName'||Required
attribute that specifies the name of the MultiLoad
When you specify the name in a Teradata PT job script, it is the named routine rather than a data source that provides the input data records.
The INMOD is found in the directory defined in the system-dependent library path. Using the “./” syntax (for example ./mlinmod) indicates the directory in which the job is run.
|InmodParameter = 'myParameter'||Optional attribute that specifies the second parameter of the MultiLoad INMOD routines.|
|PrivateLogName = 'logName'||Optional
attribute that specifies the name of a log that is
maintained by the Teradata PT Logger inside the
public log. The private log contains all of the
diagnostic trace messages produced by the
The file name is appended with the operator instance number. A “-1” be appends to the log name for instance 1. For example, if PrivateLogName = 'MLINlog', then the actual log name for instance 1 is MLINlog-1. Similarly, for instance 2, is MLINlog-2, etc.
The private log can be viewed using the tlogview command as follows, where jobId is the Teradata PT job name and privateLogName is the value for the operator’s PrivateLogName attribute:
tlogview -j jobid -f privatelogname
If the private log is not specified, all output is stored in the public log.
For more information about the tlogview command, see Teradata PT Utility Commands.
|TraceLevel = 'level'||Optional
attribute that specifies the types of diagnostic
messages that are written by each instance of the
operator to the public log (or private log, if one
is specified using the PrivateLogName attribute).
The diagnostic trace function provides more
detailed information in the log file to aid in
problem tracking and diagnosis.
The trace levels are:
If you use the PrivateLogFile attribute to specify a log file but do not specify the TraceLevel attribute, the following minimal statistics are displayed:
The TraceLevel attribute is provided as a diagnostic aid only. The amount and type of additional information provided by this attribute will change to meet evolving needs from release to release.
When the MultiLoad INMOD Adapter operator is used as a filter-type operator, it does not show any diagnostic messages.
|VARCHAR||Keyword that specifies VARCHAR as the data type of the defined attribute.|