Re: PROBLEM WITH OPNQRYF

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.