Step 3 Workfile Sort/Merge
The logical workfiles produced by the database load (Step 2) contain the logical child and logical parent records found in the original DL/I data.
The logical workfiles produced by the database load (Step 2) contain the logical child and logical parent records found in the original DL/I data. The workfile sort/merge step sorts the logical child records under their related parents.
If the database load processed multiple DL/I databases, you will have a separate workfile for each database. If this is the case, you must first merge all of the generated workfiles into one workfile. You can then sort this one workfile.
To perform the workfile sort/merge step, you must use your own sort/merge facility.
The workfile sort/merge performs the following operations:
- Accessing the workfile(s) resulting from the database load
- Merging multiple workfiles (from multiple, logically related DL/I databases)
- Sorting the workfile so that logical child records are sequenced under their logical parents
To execute the workfile sort/merge step, use the JCL in CA IDMS DLI Transparency JCL. The following diagram shows a workfile sort/merge: