I have loaded a HDAM database with the PSB having PROCOPT=LS for it and the input data in the sequential order. Now i want to retrieve the data from the database in the sequential order.
I tried using GET-NEXT followed by GET-NEXT-PARENT for child segment.
The database has following hierarchy:
ABCD Segment is root,
EFGH is child of ABCD,
IJKL is the child of EFGH.
The output i am getting is not sequential though the loading is in sequential order. The FIELD in the DBD has the param (ABCDKEY,SEQ,U).
Please suggest what wrong and the correct way. Need a solution which would possibly not change the DBD or PSB.
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
The ONLY time that you will ever retrieve a HDAM database in sequential order is immediately after you load it - before anyone else has access. HDAM is much quicker for online applications, but HIDAM is a must for sequential retrieval.
When using HDAM you will need to create an extract file and then use an external sort.