× 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.



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
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.