Dan,
After the Opnqryf do cpyfrmqryf in a test file and have a look at the
data you are extracting. The quality of the data can make all the
difference.
Emmanuel
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Rasch
Sent: 30 March 2009 8:47 PM
To: midrange-l@xxxxxxxxxxxx
Subject: OPNQRYF looks good, bad results
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.
This email and any attachment(s) may contain information
which is personal or otherwise confidential and/or privileged.
Unauthorised access, use, distribution, reproduction or
disclosure is prohibited. If you are not the intended recipient
and/or received this message in error please tell us by reply
(or telephone the sender) and delete all copies from your
system. Any privilege, confidentiality or copyright that
attaches to this email is not waived, lost or destroyed if you
have received this email in error.
We do not warrant that this email and any attachment(s) is
free from viruses or defects and you should scan this email
for viruses prior to opening or saving any attachments. The
Hogg Robinson Group accepts no liability for any damage
caused by any virus transmitted by this email.
Statements or opinions expressed in this email may be
personal to the sender and do not necessarily represent the
views of Hogg Robinson Plc or any other member of the Hogg
Robinson Group. Unless expressly stated otherwise, no
member of the Hogg Robinson Group is bound by any
contract or obligation purported to be created by this email or
its attachment(s).
HRG and HRG worldwide network are all Hogg Robinson
Group trading names and trade marks.
This email and any attachment(s) is © Hogg Robinson Plc
(trading as HRG - Incorporated and Registered in England
and Wales, Registered Office: Global House, Victoria Street,
Basingstoke, Hampshire RG21 3BT, UK. Company No.
2107443. VAT No. GB413640679)
midrange.com
