×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.




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

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.