17.10 - Step 3 – Opening a Teradata Access Module for OLE DB 17.10 amj File That Contains Multiple Jobs - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval
  1. In the Teradata OleLoad dialog box, select File > Open.
  2. Select the test.amj file (which has 2 jobs in it) and click Open.
  3. Select the job and click OK.
    Oleload loads the job.

Opening a Teradata Access Module for OLE DB 17.10 .amj File

The user has two OLEDB Access Module 17.10 amj files:
  • test.amj has 25 jobs stored in it.
  • test1.amj has 30 jobs stored in it.

In the first scenario, the user opens job30 from test1.amj and wants to store the same job in test.amj. The job will be stored as job26 in test.amj, irrespective of whether or not the Append to this file check box is selected at the time of saving, because there is no job30 in test.amj.

In the second scenario, the user opens job15 from test1.amj and wants to store the same in test.amj. The job will be stored as job26 in test.amj if the Append to this file check box is selected at the time of saving. If the Append to this file check box is not selected, the Teradata Access Module for OLE DB will overwrite the job15 already present in test.amj file.

Performance can be affected if more than 50 jobs are stored in a single .amj file.