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.
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