Use the attribute definition list syntax in the Teradata PT DEFINE OPERATOR statement to declare the required and optional attribute values for the FastExport OUTMOD Adapter operator.
where:
Syntax Element | Description |
---|---|
AccessModuleInitStr = 'initString' | Optional attribute that specifies the initialization string for the specified access module. For initString values to the Initialization String section for each access module in the Teradata Tools and Utilities Access Module Reference (B035-2425). |
AccessModule Name = 'name' | Optional attribute that specifies the name of the access module
file, where the value for name is dependent
on the following: Teradata Access Module for Named Pipes
Teradata Access Module for WebSphere MQ for Teradata Parallel Transporter (client version)
Teradata Access Module for WebSphere MQ for Teradata Parallel Transporter (server version)
Use your shared library file name if you use a custom access module. Access module names do not need a suffix since the operator appends the correct suffix for the platform used. Large File Access Module is no longer available because the DataConnector operator now supports file sizes greater than 2 gigabytes on Windows, HP-UX, AIX, and Solaris running on SPARC systems, provided system parameters are appropriately set. Teradata PT supports the standalone version of the Teradata Access Module for Named Pipes and Teradata Access Module forWebSphere MQ. The Teradata PT version of the Teradata Access Module for Named Pipes and Teradata Access Module for WebSphere MQ is not supported. |
FileName = 'fileName' | Optional attribute that specifies the name of the file. On the UNIX system, limited to 255 bytes. |
Format = 'option' | Optional attribute that specifies the logical record format of the file being read. A value is not needed as long as the attached access module generates data in a predefined format. If no predefined format exists, one of the following values is required because no system default exists:
|
IndicatorMode = 'mode' | Optional attribute that specifies whether indicator byte(s) is included at the beginning of each record.
|
OpenMode = 'mode' | Optional attribute that specifies the read/write access mode.
|
OutmodName = 'moduleName' | Required attribute that specifies the name of the FastExport OUTMOD routine to be loaded. The OUTMOD is found in the directory defined in the system-dependent library path. Using the “./” syntax (for example ./floutmod) indicates the directory in which the job is run. |
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 output provided by the operator. 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. |
TextDelimiter = 'c' | Optional attribute that specifies the character that separates fields in delimited records. The default is the pipe character ( | ). |
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, the TraceLevel value defaults to 'Milestones'. The TraceLevel attribute is provided as a diagnostic aid only. The amount and type of additional information provided by this attribute changes to meet evolving needs from release to release.
|