RE: OPNQRYF question

Yep...I hear ya.....if that's all I wanted....I could sure do that.
But this is just step #1 in the process.

I have other things going on in my CL that will need this file.
like to send out an e-mail message using SNDDST and other things.


-----Original Message-----
From: Shannon O'Donnell [mailto:shannono@xxxxxxxxxxxxxxx] 
Sent: Friday, May 30, 2003 10:48 AM
To: Midrange Systems Technical Discussion
Subject: 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.


_______________________________________________
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.