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(PAYMST)
    OVRDBF FILE(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
    NAME 'F0001 9 36' is incorrect. It should read NAME 'F00001 9 36'

    Note four zeros F00001 instead of F0001.

    Dave

    Comment

    Working...
    X