IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Retrieve the Database in Seq order


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
milochanzy

New User


Joined: 28 Aug 2006
Posts: 7
Location: India

PostPosted: Mon Dec 24, 2007 7:29 pm
Reply with quote

Hi,

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.

Thanks,
Milo.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Dec 27, 2007 6:41 pm
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Rotate partition-logical & physic... DB2 0
No new posts What database does Jobtrac use CA Products 4
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
Search our Forums:

Back to Top