Re: OPNQRYF question

["Reggie Acosta" <racosta@xxxxxxxxxxxxxxx>]

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

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

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 ??

                  


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