FW: OVRDBF *all -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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.

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.