|
There's also GTSOUR *EQ "AR" lines in there also. I know this is quite
messy. Its not my code however. I'm just trying to add to it.
----------------------------------------------------------------------
From: "Lapeyre, Francis" <FLAPEYRE@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 14:32:22 -0500
>It can be boiled down to:
>
>
>QSYS/OPNQRYF FILE((DOR400/GLTRAN)) QRYSLT('GTBDTE *EQ ' +
> *CAT &BOOK *CAT ' *AND GTACCT *EQ +
> %VALUES(3120 3140 3150 3170) *AND GTSOUR *EQ +
> "BI" *AND GTDIV *EQ &DIV') KEYFLD((GTREF))
>
>You can also replace the *EQ with =.
>
>Francis Lapeyre
>IS Dept. Programmer/Analyst
>Stewart Enterprises, Inc.
>E-mail: flapeyre@xxxxxxxx
>
>-----Original Message-----
>From: midrange-l-bounces@xxxxxxxxxxxx
>[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob O.
>Sent: Friday, August 18, 2006 1: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.
>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.