Re: OPNQRY PROBLEM

Darrell,

You do not to parenthese the *GT and * LT variables and the last variavble
in quotes. Something like:

('VLCOCD = %RANGE("' *TCAT &FCO *BCAT  &TCO *TCAT '") *AND VLEFDT *GT"'
*BCAT &BEGDT *BCAT '"*AND VLEFDT *LT"' *BCAT &ENDDT) 

I assume &BEGDT and & ENDDT are character  variables with numeric values

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 30-3-2007 at 8:31 DLee@xxxxxxxx wrote:

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.