Re: PROBLEM WITH OPNQRYF

["rick baird" <rick.baird@xxxxxxxxx>]

ditto on:

1. assign the select statement to a variable - then you can look at
the result in debug or a dump.
2. adding parens to group your selects.
3. changing *DIV to &DIV

I would add one more thing:

don't be afraid to use a doublequote instead of two single quotes for
wrapping your alpha constants.  It keeps me from being confused, and
i'm sure it helps the query command processor too.

;)

On 8/18/06, Bob O. <otis_the_cat@xxxxxxxxxxx> 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))
> --
> 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.