Re: Did OPNQRYF give out an empty record set?

Antonio

Not that I know of. For one thing, the actual generation of the result set
does not take place until it's opened in the RPG, so there is no
information available in the CL.

To see this, run an OPNQRYF from a command line, then CPYFRMQRYF. You don't
get the "records selected, records processed" message until you execute the
copy, or until you open the file in your RPG.

Be sure to close the file after the copy!!!

What do you want to do differently if there are no records? Just curious.

Regards

Vern

At 01:06 AM 11/21/2002 +0100, you wrote:

An CL pgm does an OVRDBF xxxx  SHARE(*YES), then executes an OPNQRYF,
then runs an RPG pgm. Sometimes the selected conditions result in an
empty selection, so the RPG pgm reading ( I P , sequential processing)
the opened file will directly set  LR and end.
If this was a normal file, I could know in advance the file was empty
with RTVMBRD  number of records, but cannot with the result of the
OPNQRYF.
Is there any way to find out whether the result file is/isnot empty
before running the RPG pgm?
TIA
-------------------------
Antonio Fernandez-Vicenti
afvaiv@wanadoo.es