+ Reply to Thread
Results 1 to 2 of 2

Thread: OPNQRY result issue

  1. #1

    Default OPNQRY result issue

    I've got an OPNQRY thqt if I put the results into a file via CPYFRMQRYF the dataset is correct, but if I run DSPPFM on the file it doesn't.

    The code I use:

    DCL VAR(&SELECTA) TYPE(*CHAR) LEN(93) +
    VALUE('CONO55 *EQ "DA" +
    *AND DNSD55 *EQ 1130102 +
    *AND (ORDN55 *GE "0607691" *AND +
    ORDN55 *LE "0607691")')

    OVRDBF FILE(OEP55) SHARE(*YES)

    OPNQRYF FILE((OEP55 *FIRST *ONLY) (OEP55E *FIRST +
    *ONLY)) OPTION(*INP) FORMAT(OEP55) +
    QRYSLT(&SELECTA) KEYFLD((OEP55/CONO55 +
    *ASCEND *N) (OEP55/ORDN55 *ASCEND *N) +
    (OEP55/ORDL55 *ASCEND *N) +
    (OEP55/CATN55 *ASCEND *N)) +
    UNIQUEKEY(4) JFLD((OEP55/CONO55 +
    OEP55E/CONO55 *EQ) (OEP55/ORDN55 +
    OEP55E/ORDN55 *EQ) (OEP55/ORDL55 +
    OEP55E/ORDL55 *EQ)) MAPFLD((CONO55 +
    'OEP55/CONO55' *CALC *N *N *CALC) +
    (ORDN55 'OEP55/ORDN55' *CALC *N *N +
    *CALC) (ORDL55 'OEP55/ORDL55' *CALC *N +
    *N *CALC)) SEQONLY(*NO)

  2. #2
    Join Date
    Jul 2011
    Location
    Decatur, IL
    Posts
    9

    Default

    Hello Stuckinparis! The DSPPFM does NOT share an existing open data path, so what you see via DSPPFM is not altered by the OPNQRYF. The CPYF command too does not share an open data path. I would assume that is why we have the CPYFRMQRYF command.
    Last edited by bbardini; 01-09-2013 at 04:42 PM.

+ Reply to 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