Re: OPNQRYF looks good, bad results

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.