a bit late, but I've been overseas (again!).
don't use OPNQRY at this point. use the IBM WRKQRY tool. you can define your fields and then sort by one or more of them to create an output file for your application to use...or you could create your report from WRKQRY and send it to the printer.
-sergeant
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
OPNQRY problem
Collapse
X
-
OPNQRY problem
Hi all,
I have a problem with opnqry. I have to sort an s36 type file with undefined fields.
K0001 1 – 8 8.0
0001 1– 2 2.0
F0001 17 – 44 28A
K0001- - > F0001 17 - 44- - - - - - - - - - - ->
01001000080ê̬¬¬ LASTNAME FIRSTNAME I PO BOX 718 Phoenix AZ85928
div
Here is my CL:
CLOF OPNID(STU.PAYMST)
OVRDBF FILE(STU.PAYMST) SHARE(*YES)
OPNQRYF FILE((PAYMST)) QRYSLT('K00001 *EQ +
01001000') KEYFLD((DIV) (NAME)) +
MAPFLD((DIV '%SST(F0001 1 2)' *ZONED 2) (NAME +
'F0001 9 36)'))
#1, it displays error: 700 - OVRDBF FILE(STU.PAYMST) SHARE(*YES)
900 - OPNQRYF FILE((STUART/STU.PAYMST)) QRYSLT('K00001 *EQ 01001000')
KEYFLD((DIV) (NAME)) MAPFLD((DIV '%SST(F0001 1 2)' *ZONED 2) (NAME
'F0001 9 36)'))
Field F0001 on MAPFLD parameter not found.
Error occurred during processing of command.
Function check. CPF9899 unmonitored by TSTQRYCL at statement 0000000900, instruction X'0000'.
#2. the RPG processes every record, it should be processing 1 record.
Thanks in advance
Leave a comment: