Re: Stored Procedures

[Peter Alan Burton <pburton@BRIO.COM>]

Todd,

In the SAMPLE directory there should be a progran DROPPROC.SQR which will drop
all the SQR created stored procedure which where left behing when SQR did not
properly end.  There is also a program SHOWPROC.SQR which will show you all
the SQR created stored procedures when have been left behind.

Peter

Todd Becker wrote:

> SQRUG,
>
> I am using SQR 4.3.2.2 / Sybase 11.x / Windows95 as my development
> environment and SQR seems to be leaving stored procedures on the database.
> There are over 30 procedures, with names like, SQR_4294834497_929551157,
> residing on our database and I'm not sure where they came from.  My guess
> is that they are temporary procs that were created and not destroyed,
> possibly because the SQR execution was interupted.  Are there any dangers
> associated with droping these procedures?  My DBA would really like to get
> rid of them, but I would like to make sure they aren't needed first.
>
> TIA,
>
> Todd