Re: OPNQRYF and RUNQRY in a CL

[Anton Gombkötö <Gombkoetoe@xxxxxxxxxx>]

I think the reason for this behaviour is the SECURE(*YES) in the OVRDBF in
IBM's CPP for RUNQRY and many other commands.

SECURE(*YES) protects the current override from any previous overrides. This
is nice for tools and worked before the overrides on *JOB or *ACTGRP level.

The solution for your problem is the CPYFRMQRYF as Chris Bipes wrote.

0.02 Euro

Anton Gombkötö

----- Original Message -----
From: "Martin, Booth" <BoothM@goddard.edu>
To: <RPG400-L@midrange.com>
Sent: Friday, February 18, 2000 10:52 PM
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?
>
> 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
+---