RE: OPNQRY PROBLEM

["Kesterson, Randy" <RPKesterson@xxxxxxxxxxxxxxxxxxx>]

You're putting "s around your variable date fields.  Get rid of them.

________________________________________________________________________
______________________
Randy Kesterson, Information Services
Market Transport Services  - a UTi Worldwide Company| 110 N Marine Drive
| Portland, OR 97217 | USA
rpkesterson@xxxxxxxxxxxxxxxxxxx | D +1 503.978.4353 | O +1 503.283.2405
x353 | F +1 503.978.4392 
 
 
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of DLee@xxxxxxxx
Sent: Friday, March 30, 2007 6:31 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: OPNQRY PROBLEM

Morning all;

A little problem I having.  I have a push to get this running, and it's 
fighting back.

This opnqryf isn't working for me, after years of doing them, (cloning 
mostly) I can't seem to make this one work.

OPNQRYF    FILE((DTLRES)) OPTION(*INP) + 
             QRYSLT('VLCOCD=%RANGE("' *CAT &FCO *CAT + 
             '" "' *CAT &TCO *CAT '") + 
             *AND VLEFDT *GT("' *CAT &BEGDT *CAT '"   + 
             *AND VLEFDT *LT("' *CAT &ENDDT *CAT '"') + 
             KEYFLD((VLCOCD) (VLEFYY) (VLREIN) (VLRD) + 
             (VLTYPE) (VLCOVC)) 

It compiles okay, but blows up with this error -  Character '('
following 
string '*GT         ' not valid. 

In debug, I'm able to see all the variables,   It's probably an
apostrophe 
or something but I'm not seeing it. 

VLEFDT  is a  numeric date 8s0

extended help  Makes no sense to me.

Cause . . . . . :   A character that was specified in the expression on

  parameter QRYSLT, at position 41 is not valid.  A delimiter or some 
required 
  characters may have been omitted, such as the decimal digit characters

after 
  a leading decimal point, or the decimal point in a floating-point 
constant. 
  If the error occurred on the MAPFLD parameter, the expression was 
specified 
  for the definition of field *N.  For more information on delimiters,
see 
the 
  CL Reference topic in the Information Center book,  
  http://www.ibm.com/eserver/iseries/infocenter.  
Recovery  . . . :   Either omit the character that is not valid or
specify 
a 
  valid delimiter character (if one is missing). Then try the request 
again. 

Appreciate any help

Darrell Lee
Information Technology
Extension 7127