Re: OPNQRYF looks good, bad results

[Alan Campin <alan0307d@xxxxxxxxx>]

Running in an ILE environment? Is the key on the POMST by PO#? The default
on OVRDBF is to share the override within the activation group. I have never
ever got that to work. I always have to share at the job level to make it
work.

OVRDBF FILE(POMST) SHARE(*YES) OPNSCOPE(*JOB)


On Mon, Mar 30, 2009 at 1:46 PM, Dan Rasch <drasch27@xxxxxxxxxxx> wrote:

> I am trying to use OPNQRYF to choose between four user options to order a
> report.
>
> I run the OVRDBF, and it looks fine:
>
>
>
> OVRDBF FILE(POMST) SHARE(*YES)
>
>
>
> Then, I run one of the four OVRDBF's.  Here's one example:
>
>
>
> OPNQRYF FILE(POMST) OPTION(*ALL) +
>
> QRYSLT('(POMSTS = ''0'') *AND (POMCPY = 01 )') +
>
> KEYFLD((POMLOC) (POMVNM) (POMVCD) (POMPON))  +
>
> OPTIMIZE(*FIRSTIO) SEQONLY(*YES 10)
>
>
>
> It runs with no error, and I am expecting to read the file by:
>
>   location, vendor name, vendor code, and PO#
>
> (as coded).  What I get is by PO#.
>
>
>
> Any ideas?
>
>
>
> Thanks,
>
> - Dan
>
> _________________________________________________________________
> Internet Explorer 8 – Get your Hotmail Accelerated.  Download free!
> http://clk.atdmt.com/MRT/go/141323790/direct/01/
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.