Re: OPNQRYF and RUNQRY in a CL

Martin,

I know that SQL doesn't share open files within a job, and I don't think
that RUNQRY does. If I were you I would forget about OPNQRYF and RUNQRY,
and use STRQMQRY as a single solution, passing the date as a parameter. 

Regards

Vanja Jovic,

Canada

"Martin, Booth" wrote:
> 
> 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?
> 
> tia
> +---
> | 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
> +---
+---
| 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
+---