RE: PROBLEM WITH OPNQRYF

["mlazarus@xxxxxxxxxxxxx" <mlazarus@xxxxxxxxxxxxx>]

Bob,

 There are a couple of places where (almost certainly) *DIV should be &DIV.
Also, you should be doing the *CAT's for the &DIV variable, similar to what
you did with the &BOOK variable.

 You may also want to restructure the statement with parentheses, so that
you are not repeating the same conditions for each group.  Look at the
%VALUES() function.

 Another tip is to assign the query select string into a variable.  That
will allow you to view it in debug before it hits the OPNQRYF.

 I would also suggest using double quotes, instead of two single quotes
around constants.

 -mark

Original Message:
-----------------
From: Bob O. otis_the_cat@xxxxxxxxxxx
Date: Fri, 18 Aug 2006 13:52:00 -0500
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))


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .