Re: OPNQRYF - Zero records

["Brad Stone" <brad@xxxxxxxxxxxx>]

I would suggest even a better way.  Using SQL you can do
your OPNQRYF and select the number of records in the result
set.  I find this much more accomodating than OPNQRYF,
although if you're not familiar with it, it will take some
learning time.

Brad
www.bvstools.com

> >>> <Steven.Gray@arvalphh.co.uk> 02/05/02 07:00AM >>>
> I am trying to test if the OPNQRYF file produced has no
> records from the
> selection criteria.
>
> I can do this by using the DSPFD to an OUTFILE and then
> using DCLF and RCVF
> to read the 1st record which will contain the &field
> MBNRCD , to inform me
> if there are indeed 0 records.
>
> But,
>
> is this the best way to go ,
>
> as this will only allow 1 file comparison in the CL
> program.
>
> If I want to test any more files for zero records , then
> they have to have
> their own CL programs.Which is obviously not ideal.
> Also the testing of this is messy , as another file has
> to be created which
> holds the testing files data.
>
> Regards
>
> Steven Gray
> Development/Support Analyst
>