Page 1 of 1

File Manager/IMS Extract

PostPosted: Wed May 14, 2014 10:49 pm
by gmosley
Does anyone know if it's possible to do an extract via a secondary index using the "keys" option?

Re: File Manager/IMS Extract

PostPosted: Thu May 15, 2014 8:00 pm
by Ed Goodman
This looks so much like another question in DB2, it makes me wonder what you're actually trying to do.

Where would the "keys" option go anyway?

Re: File Manager/IMS Extract

PostPosted: Thu May 15, 2014 9:09 pm
by gmosley
A subordinate segment of a database (CLAIMS) contains a non-key field (REGI#). REGI# is the key for the secondary index.
I have a list of REGI# values that I want to use to extract the DB records from the CLAIMS database.
I know I can do it with Rexx code and IEB but that means reading the whole CLAIMS DB.
Since I can retrieve CLAIMS DB records in Browse by REGI# using the secondary index, it seems logical to assume I could extract that way.

Re: File Manager/IMS Extract

PostPosted: Thu May 15, 2014 11:22 pm
by dick scherrer
Hello,

You do NOT want to read the Claims data via REXX. There might be a worse choice, but I am not sure what it would be.

Re: File Manager/IMS Extract

PostPosted: Fri May 16, 2014 3:10 am
by Ed Goodman
Makes sense... I guess I would give a try at extracting via secondary first, then try to add a keys database.

I think what you'll get is an unload of the secondary segments, but they might have the full key on them from the root. You could take that and massage it to have just the root keys, then feed THAT file back through an extract of the primary.