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

IBM FileManager IMS extract limit parameter


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
No new posts Using the Jobname parameter in a Qual... ABENDS & Debugging 1
No new posts optim extract file - SAS DB2 2
No new posts Demand with DEADLINE TIME parameter CA Products 4
No new posts How to extract the data for current y... DFSORT/ICETOOL 8
Search our Forums:

Back to Top