Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

OPNQRY problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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

    Comment

    Working...
    X