Access Modules with the Teradata PT DataConnector Operator
Teradata PT operators, which simulate some of the functions of Teradata FastExport, Teradata FastLoad, and others, interface with Access Modules through the Teradata PT DataConnector operator. Access Modules can be incorporated into a Teradata PT job as long as the Access Module are defined for a job script.
To define an Access Module in a Teradata PT job script
1 Include the following program text within the DEFINE OPERATOR ATTRIBUTES clause of the DataConnector definition (in addition to the other attributes being defined):
(
VARCHAR AccessModuleName,
VARCHAR AccessModuleInitStr
)
where:
2 Define the Access Module attributes within the APPLY or SELECT clause in which you are using the DataConnector operator. For example:
SELECT * FROM OPERATOR
( DC_FILE_READER() [1]
ATTR
(
PrivateLogName = 'dcR.log',
FileName = './dummy',
OpenMode = 'Read',
Format = 'Text',
IndicatorMode = 'No',
AccessModuleName = 'libmqs.so',
AccessModuleInitStr = '-qmgr SYSQ1 -qnm MyQ -TRCL 2
MQTRCE.txt'
)
);
Note: For the appropriate value to assign to the Format attribute, refer to specific Access Module documentation.