Re: OPNQRYF question

I guess I didn't read the first post as well as I should have.  Sorry for
being misleading in my previous posts.


Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                                
                                                                      
                    "Reggie Acosta"                                             
                                                                      
                    <racosta@xxxxxxxxxxxx        To:     
<midrange-l@xxxxxxxxxxxx>                                                       
             
                    com>                         cc:                            
                                                                      
                    Sent by:                     Subject:     Re: OPNQRYF 
question                                                                    
                    midrange-l-bounces@xx                                       
                                                                      
                    drange.com                                                  
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      
                    05/30/2003 12:17 PM                                         
                                                                      
                    Please respond to                                           
                                                                      
                    Midrange Systems                                            
                                                                      
                    Technical Discussion                                        
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      




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






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