Re: Deleting Stored Procedures

["John Candidi" <jacandidi@xxxxxxxxxxxxxxxxxxxx>]

Thank You..We think we need a reinstall on the Ops Nav..It seems to be
missing some other basic components
----- Original Message ----- 
From: <MWalter@xxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, April 05, 2005 2:19 PM
Subject: Re: Deleting Stored Procedures


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