Re: OPNQRYF question

["Reggie Acosta" <racosta@xxxxxxxxxxxxxxx>]

The OPNQRYF QRYSLT parameter does not use SQL statements. 

------------------------------

message: 9
date: Fri, 30 May 2003 10:39:21 -0500
from: "Norbut, Jim" <Jim.Norbut@xxxxxxxxxxxxxxx>
subject: OPNQRYF question

I created a file called PWDEXPFILE using DSPUSRPRF and sent to an outfile in
my library

now using a CL I am trying to get info on anyone who hasn't reset their
password in 30 days

 

But I am getting an CPD3120 error (that is the detailed description when I
hit F1)

it's actually CPF9899 that shows up in the joblog.

 

 

OPNQRYF    FILE((JNORBUT/PWDEXPFILE)) OPTION(*ALL) +    

                    QRYSLT('SELECT * FROM JNORBUT/PWDEXPFILE + 

                    WHERE DATE(SUBSTR(UPPWCD,3,2)|| +          

                                      "/"||SUBSTR(UPPWCD,5,2)|| +


                                      "/"||SUBSTR(UPPWCD,1,2)) >= +


                    CURRENT_DATE - 30 DAYS') 

 

 

 

am I not able to do this using OPNQRYF ??