Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Retrieve the Database in Seq order

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Retrieve the Database in Seq order
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Need to retrieve Julian_date Suganya87 DB2 4 Wed Aug 17, 2016 7:27 pm
No new posts SQL Order By related question Joseph K Thomas DB2 8 Fri Mar 18, 2016 12:53 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us