Defining an Access Module in a Teradata PT Job Script - Access Module

Teradata® Tools and Utilities Access Module Programmer Guide

Product
Access Module
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ung1608578381741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2424
lifecycle
previous
Product Category
Teradata Tools and Utilities
  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:
    • AccessModuleName specifies the file name of the dynamically loadable module that provides the Access Module software.
    • AccessModuleInitStr specifies the Access Module initialization string, which is a list of operational parameters that you can specify for an Access Module. The contents of the initialization string are determined by the requirements of the specified Access Module.
  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'
        )
      );
    For the appropriate value to assign to the Format attribute, refer to specific Access Module documentation.