Re: stored procedure Drop/Remove/Delete

Are you getting a message or something?

Another way to look is to open iSeries Navigator.  Open your system, then
Databases, select the library where you think the stored procedure should
be.  While the actual object does not reside in this library (you've
already seen it in SYSPROCS) Navigator will allow you to access it this
way.  I think they did a nice job of tying it all together.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                      "John Ross"
                      <jross-ml@netshare        To:       
midrange-l@midrange.com
                      400.com>                  cc:
                      Sent by:                  Fax to:
                      midrange-l-admin@m        Subject:  Re: stored procedure 
Drop/Remove/Delete
                      idrange.com


                      09/20/2002 11:33
                      AM
                      Please respond to
                      midrange-l






Ok I should of looked at the FAQ's first.
http://faq.midrange.com/index.pl?_recurse=1&file=25#file_188
But I can not get drop procedure to work, in STRSQL or from a command line.

I also found that they are stored in file SYSPROCS in library QSYS2

Thank You
John Ross

On Fri, 20 Sep 2002 11:07:43 -0500
 "John Ross" <jross-ml@netshare400.com> wrote:
> I did a strsql  CREATE PROCEDURE  and there is a DROP for about every
thing execpt a
> proedure? How do I get rid of it?
>
> Also where are stored procedures stored? They have Surveyor/400 and it
shows a folder
> with
> stored procedures, just wondering about this?
>
> Thank You
> John Ross
>
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.