RE: PROBLEM WITH OPNQRYF

  There were some errors in your command and I changed it to what is
  above. As you can see, I added "AR" to your version.  I need to check for
  both "BI" and "AR".

  I also had to take out the single quotes around the *BCAT &DIV to get it
  to compile.  Even after using this command, I am still getting the CPF9899
  error.

    ----------------------------------------------------------------------

    From:  "Forbes, Vincent" <Vincent.Forbes@xxxxxxxx>
    Reply-To:  Midrange Systems Technical Discussion
    <midrange-l@xxxxxxxxxxxx>
    To:  "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
    Subject:  RE: PROBLEM WITH OPNQRYF
    Date:  Fri, 18 Aug 2006 15:39:14 -0400
    >Try
    >
    >OPNQRYF FILE((DOR400/GLTRAN)) +
    >   QRYSLT(' +
    >     GTACCT *EQ %VALUES(3120 3140 3150 3170) *AND +
    >     GTBDTE *EQ' *BCAT &BOOK *BCAT  '*AND +
    >     GTSOUR *EQ "BI" *AND +
    >     GTDIV  *EQ' *BCAT &DIV
    >     ')  +
    >   KEYFLD((GTREF))
    >
    >
    >\Vincent
    >
    >
    >-----Original Message-----
    >From: midrange-l-bounces@xxxxxxxxxxxx
    >[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Forbes, Vincent
    >Sent: Friday, August 18, 2006 3:13 PM
    >To: Midrange Systems Technical Discussion
    >Subject: RE: PROBLEM WITH OPNQRYF
    >
    >Use double quotes " around character constants not two single quotes '.
    >
    >\Vincent
    >
    >-----Original Message-----
    >From: midrange-l-bounces@xxxxxxxxxxxx
    >[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob O.
    >Sent: Friday, August 18, 2006 2:52 PM
    >To: midrange-l@xxxxxxxxxxxx
    >Subject: PROBLEM WITH OPNQRYF
    >
    >    I can't seem to get this to work no matter what I do!!!
    >
    >    I keep getting the following message in the job log.
    >
    >    CPF9899
    >    Missing operand on expression in QRYSLT parameter.
    >
    >
    >    QSYS/OPNQRYF FILE((DOR400/GLTRAN))  QRYSLT('GTBDTE *EQ
    '  *CAT  &BOOK
    >
    >    *CAT  ' +
    >    *AND GTACCT *EQ 3120 +
    >    *AND GTSOUR *EQ ''BI'' +
    >    *AND GTDIV *EQ *DIV *OR +
    >    GTBDTE *EQ '  *CAT  &BOOK  *CAT  ' +
    >    *AND GTACCT *EQ 3140 +
    >    *AND GTSOUR *EQ ''BI'' +
    >    *AND GTDIV *EQ &DIV *OR +
    >    GTBDTE *EQ '  *CAT  &BOOK  *CAT  ' +
    >    *AND GTACCT *EQ 3150 +
    >    *AND GTSOUR *EQ ''BI'' +
    >    *AND GTDIV *EQ &DIV *OR +
    >    GTBDTE *EQ '  *CAT  &BOOK  *CAT  ' +
    >    *AND GTACCT *EQ 3170 +
    >    *AND GTSOUR *EQ ''BI'' +
    >    *AND GTDIV *EQ *DIV ')  +
    >    KEYFLD((GTREF))
    >--
    >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
    >list
    >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
    >To subscribe, unsubscribe, or change list options,
    >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
    >or email: MIDRANGE-L-request@xxxxxxxxxxxx
    >Before posting, please take a moment to review the archives
    >at http://archive.midrange.com/midrange-l.
    >
    >
    >--
    >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
    >list
    >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
    >To subscribe, unsubscribe, or change list options,
    >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
    >or email: MIDRANGE-L-request@xxxxxxxxxxxx
    >Before posting, please take a moment to review the archives
    >at http://archive.midrange.com/midrange-l.
    >
    >
    >--
    >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
    list
    >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
    >To subscribe, unsubscribe, or change list options,
    >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
    >or email: MIDRANGE-L-request@xxxxxxxxxxxx
    >Before posting, please take a moment to review the archives
    >at http://archive.midrange.com/midrange-l.
    >