+ Reply to Thread
Results 1 to 2 of 2

Thread: OPNQRY problem

  1. #1

    Default 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. #2

    Default

    NAME 'F0001 9 36' is incorrect. It should read NAME 'F00001 9 36'

    Note four zeros F00001 instead of F0001.

    Dave

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts