Ask the Expert

Use OPNQRYF against a multi-format logical file

Is it possible to use OPNQRYF against a multi-format logical file so that I get records from each of the formats? Our order header records are stored in two files -- current and history. Currently, we execute the OPNQRYF command twice, once for each of the formats in this logical file.

If the files contain different record formats, you would need both OPNQRYF commands. If it is the same record format, and multiple members, OVRDBF FILE(A) MBR(*ALL) will put all of the members of your logical in the data path. If there are multiple record formats, this will do nothing to help you.


The Best Web Links: tips, tutorials and more.

Ask your programming questions--or help out your peers by answering them--in our live discussion forums.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.

This was first published in April 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: