Re: OPNQRYF question

Why not just use the SECTOOLS menu to run that report?


Shannon O'Donnell


----- Original Message ----- 
From: "Norbut, Jim" <Jim.Norbut@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, May 30, 2003 10:39 AM
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 ??

                  

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.