RE: OPNQRYF and RUNQRY in a CL

Nope.  You cannot query a query without writing to a results file first.
Put a cpyfrmqryf between the opnqryf and the runqry.  

Opnqryf....
cpyfrmqryf....tofile(qtemp/xxxx)
clof...
runqry qryname qryfile(qtemp/xxxx)


Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.         http://www.cross-check.com
6119 State Farm Drive    Phone: 707 586-0551 x 1102
Rohnert Park CA  94928 Fax: 707 586-1884

*Note to Recruiters
Neither I, nor anyone that I know of, is interested in any new and/or
exciting positions. Please do not contact me.


-----Original Message-----
From: Martin, Booth [mailto:BoothM@goddard.edu]
Sent: Friday, February 18, 2000 1:52 PM
To: 'RPG400-L@midrange.com'
Subject: OPNQRYF and RUNQRY in a CL


I don't know that this is RPG, but it doesn't seem to be right for the
midrange-l list either, so here goes.

We have a CL that displays a date selection screen, validates the dates,
converts them to YYYYMMDD, selects records from a file with OPNQRY, then
runs a RUNQRY against the selected records.  We have an OVRDBF SHARE(*YES)
on the file.

The program runs, the values are as we want them, but the RUNQRY selects
every record in the file.  

The first question is: Will RUNQRY actually use the OVRDBF from OPNQRYF?
The second question is: Any suggestions on what may be messed up?
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---