Re: OPNQRYF looks good, bad results

I'd also change SEQONLY to *NO.

alan0307d@xxxxxxxxx 03/30/2009 12:08:00 PM >>>

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