Re: PROBLEM WITH OPNQRYF

[Booth Martin <booth@xxxxxxxxxxxx>]

A helpful hint that gets me through these messes is to define a variable 
of DCL &SEL *CHAR 200 and then do a CHGVAR, changing &SELECT to your 
select statement below.  Then, in debug you can look at the statement as 
assembled and you will see the issue very quickly.  You can also do a 
SNDPGMMSG &SEL if you'd rather.

If it is a batch submission then copy the CL to an an experimental CL 
and strip out everything else and run it interactively,  There is no 
need to go past the opnqryf statement.

Hope this helps.

Bob O. wrote:
>    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))