Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 How to place name of the file where t... danielgp89 SYNCSORT 18 Thu Oct 17, 2019 12:55 am
No new posts Can we pass the value of Symbolic par... Poha Eater JCL & VSAM 5 Thu Sep 05, 2019 2:21 pm
No new posts Increase the Maximum Length of LRECL ... Dhineshpondy7 JCL & VSAM 5 Wed Aug 07, 2019 6:23 pm
This topic is locked: you cannot edit posts or make replies. Removing duplicate record based on th... Nilanjan Sikdar DFSORT/ICETOOL 4 Mon Jul 22, 2019 8:29 pm
No new posts SDSF limit access to specifc output c... David Beckham All Other Mainframe Topics 1 Thu Mar 21, 2019 10:29 pm

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