16.10 - Job Files - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K
An access module job is a set of parameters defining OLE DB data source information to the Teradata Access Module for OLE DB. Access module jobs include the following parameters:
  • Data source details for both of the data sources supplying and receiving data
  • Table name for the data source supplying data
  • List of columns for the data source supplying data

The Teradata Access Module for OLE DB uses .amj files that include the name of the file containing the information used by the access module when the job was executed; for example, filename.amj. An .amj file that loads a table from Oracle might include such information as the specific OLE DB provider to be used, the name of the Oracle database server containing the table to be loaded, the user name and password to log on that server, and the name of the table to be loaded.

The Teradata Access Module for OLE DB does not use the convention of using the name of the data source as the pathname for an operation.
Use the filename.amj name for the following:
  • FILE = filename specification in the IMPORT command in a BTEQ load job script
  • FILE = filename specification in the EXPORT command in a BTEQ export job script
  • OUTFILE fileid specification in the .EXPORT command in a FastExport job script
  • FILE = filename specification in the DEFINE command in a FastLoad job script
  • INFILE filename specification in the IMPORT command in a MultiLoad or TPump job script
  • Value of the FileName attribute specification in the DATACONNECTOR operator definition in a Teradata PT job script