View previous topic :: View next topic
|
Author |
Message |
Ed Goodman
Active Member
Joined: 08 Jun 2011 Posts: 556 Location: USA
|
|
|
|
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 |
|
|
Ed Goodman
Active Member
Joined: 08 Jun 2011 Posts: 556 Location: USA
|
|
|
|
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 |
|
|
|