Re: OPNQRYF question

["Reggie Acosta" <racosta@xxxxxxxxxxxxxxx>]

I see what you mean. CURRENT_DATE - ''%DURDAY(30)''') won't work anyway. He
should probably just skip the OPNQRYF and use whatever flavor of SQL he has
available. 

Sorry for wasting bandwidth.

> from: "Richard B Baird" <rbaird@xxxxxxxxxxxxxxxxxxxxx>
> subject: Re: OPNQRYF question
> 
> 
> Reggie,
> 
> I think UPPWCD is a field from the file - not a CL variable.
> 
> he'd have to do a *MAPFLD to substring out the file variable 
> for comparison.
> 
> Rick
> 
> ------original message-------
> Ooops! Fat fingers.
> 
> Try this...
> 
> OPNQRYF    FILE((JNORBUT/PWDEXPFILE)) OPTION(*ALL) +
>                     QRYSLT('%DATE(''%SST(&UPPWCD 3 2)||''/''||+
>                                     %SST(&UPPWCD 5 2)||''/''||+
>                                     %SST(&UPPWCD 1 2)'' >= +
>                     CURRENT_DATE - ''%DURDAY(30)''')
> 
> (this hasn't been tested)
> 
> HTH
> Reggie
>