Re: Deleting Stored Procedures

[MWalter@xxxxxxxxxxxxxxx]

If you have the SQL development kit, you can try DROP PROCEDURE from the
STRSQL command.

Thanks,

Mark

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


                                                                           
             "John Candidi"                                                
             <jacandidi@rutger                                             
             sinsurance.com>                                            To 
             Sent by:                  <midrange-l@xxxxxxxxxxxx>           
             midrange-l-bounce                                          cc 
             s@xxxxxxxxxxxx                                                
                                                                   Subject 
                                       Deleting Stored Procedures          
             04/05/2005 02:10                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




I created two tables and a procedure on the iSeries through iSeries
Navigator (v5r2).  I wanted to delete the procedure and recreate it, but
when I right clicked, the context menu didn't have a delete option.  I
tried
logging in as the system administrator account as well as qsecofr incase it
was a permissions issue, but I have no way of deleting the objects.  It
doesn't allow for any other database objects either, not just the newly
created ones.

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