FW: OVRDBF *all

["Karen Summers" <ksummers@xxxxxxxxxxxxx>]

OPNQRYF acts on a single member unless you are joining.  A long time ago we were operating on multiple members and did a DSPFD TYPE(*MBRLIST) to an OUTFILE and then did a loop around a RCVF reading the members from the OUTFILE and using the member name variable in the subsequent overrides.  I am sure there is a more elegant way to do this, but we were in a hurry (surprise) and this works.

Karen

 

-----Original Message-----
From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com] On Behalf Of Rajeev Asthana
Sent: Tuesday, February 08, 2000 10:17 AM
To: CL
Subject: OVRDBF *all

Hi All,

 

I'm back after a long gap.

My question is:

I'm using OVRDBF to override all the source members of a Source file by specifying MBR(*ALL) like this:

OVRDBF FILE(SOURCES) TOFILE(LIB/QRPGSRC) MBR(*ALL).

Then I'm using STRSQL/OPNQRYF to operate on the members by uising SOURCES.

But I'm getting error that MBR(*ALL) is not valid.

Can't I use MBR(*ALL) for STRSQL/OPNQRYF? If no, what's the other way?

 

Thanks in advance.

 

Rajeev.