Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 CICS RETRIEVE pshongal CICS 2 Thu Mar 08, 2018 9:15 am
No new posts Preserve order in Input File pshongal DFSORT/ICETOOL 13 Thu Dec 21, 2017 4:20 pm
No new posts Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts Sorting on text - but in non-alphabet... Roy Ware SYNCSORT 5 Wed Aug 23, 2017 9:15 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us