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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.