IBM Mainframe Forum

Does anyone know if it's possible to do an extract via a secondary index using the "keys" option?

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?

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.

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.

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.