OLE DB Access Module amj files or Access Module Job files contain the following information:
All the information is stored in XML format and is stored under a JOB element.
Prior to OLE DB Access Module 14.00 a single amj file can only contain a single JOB element. This old amj file can be used with newer versions of the OLE DB Access Module.
In case of any parameter change (Source Database or Destination Database or Source Table or List of columns in source Table) a new JOB element is required and this enforces the creation of a new amj file.
It’s a cumbersome task to maintain many amj files or job files.
In OLE DB Access Module 14.00 a new feature has been incorporated which allows the union of multiple amj files to a single amj file.
In OLE DB Access Module 14.00 amj file different jobs will be identified through their jobid’s.
Adding multiple jobs to OLE DB Access Module14.0 amj file
(If append option is not clicked then OLE DB Access Module will overwrite job1 in 1st amj file and save the unsaved job as job1 in 1st amj file.)
Using OLE DB Access Module14.0 amj file which contains multiple jobs
User has 2 OLE DB Access Module 14.0 amj files, say test.amj and test1.amj.
1. User opened Job30 from test1.amj file and wants to store the same job in test.amj file.
In such a scenario the job will be stored as job26 in test.amj file irrespective of whether the append check box is clicked or not at the time of saving as there is no job30 in test.amj file.
2. User opened job15 from test1.amj and wants to store the same in test.amj file.
In such a scenario the job will be stored as job26 in test.amj file if the append check box is clicked at the time of saving.
If the append check box is not clicked then OLE DB Access Module will overwrite the job15 already present in test.amj file.
The OLE DB Access Module 14.00 amj file encoding will be UTF-8 for all but the UTF-16 session character set.The OLE DB Access Module 14.00 amj file encoding will be UTF-16 for the UTF-16 session character set.It’s recommended to maintain a separate amj file for all the jobs which use
s the UTF-16 session character set.