| Michael Peppler 2005-12-24, 9:23 am |
| On Fri, 23 Dec 2005 11:56:27 -0800, vsv wrote:
> how to alter an ase proc thro' sybase central. There are no options
> availabe to me (at least not visible ) ase client 12.5.3
> plugin - 12.5.4
> ase server 12.5.4
> sybase central 4.3.0.2407
>
> ddl generator allows me to save in a file. as of now there doesn't seem a
> way to edit an ase proc. Is there a way other than copy & paste in isql
> that also requires changing create to alter or add drop proc statement.
Extract the proc to an OS file (a text file), edit the file with your
favorite editor, then reload the proc (I usually use isql for this).
When reloading the proc you need to drop it first, so I usually have
something like this:
if object_id('the_proc_
name') is not null
drop proc the_proc_name
go
create proc the_proc_name
.....
go
Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
|