Step 3 – Open an OLEDB Access Module 14.0 amj File That Contains Multiple Jobs
1 In the Teradata OleLoad dialog box select File > Open to open the Open dialog box.
2 Select the test.amj file (which has 2 jobs in it) and click open.
A window listing available jobs will appear.
3 Select the job and click OK.
Oleload will load the job.
The user has two OLEDB Access Module 14.0 amj files:
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 OLEDB Access Module will overwrite the job15 already present in test.amj file.
Note: Performance might be affected if more than 50 jobs are stored in a single amj file.