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
 

 

IBM FileManager IMS extract limit parameter

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Tue Jan 29, 2013 9:34 pm    Post subject: IBM FileManager IMS extract limit parameter
Reply with quote

I want to create a sub set of data the easy way. I just want to extract the first, say 10,000 roots and their children from a database. I will load that into the test environment.

I have figured out how to use a key file, and that's probably what I'll do, but is there a lazy way to tell FM/IMS to just stop after 10,000 roots?

I can't see where to add that to a criteria. I can see how to add things like field-value = 'x' to select segments, but no arbitrary limit.

I also can't see a way to invoke an exit and/or rexx routine to keep track.
Back to top
View user's profile Send private message

Ed Goodman

Active Member


Joined: 08 Jun 2011
Posts: 556
Location: USA

PostPosted: Wed Jan 30, 2013 3:29 am    Post subject:
Reply with quote

Found a temporary work around that SEEMS to be the IBM provided solution.

While viewing the database I want to extract FROM, I can type "XKEY 1000" and FileManager will spin through the databse and create a flat file contain just the primary key of every 1,000th root.

I can use that flat file as the key file in a keyed extract. It's the same thing I was going to do manually, but this saves me a few steps. the bad part is you still can't control the total number, plus you have to wait for it to scan through the ENTIRE database while it locks your session.
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 -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm
No new posts Limit CICS CPU resource vasanthz CICS 0 Tue Jan 31, 2017 7:09 am
No new posts DDNAME parameter mistah kurtz JCL & VSAM 6 Mon Dec 19, 2016 4:41 pm


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