ASE Database forum - Select statement that will display stored procedure?

Author

Select statement that will display stored procedure?

VMI

2005-04-12, 8:24 pm

Is it possible to write a Select statement that'll display
the contents of a specific stored procedure? I'm working
with SQL Advantage .

Thanks.

Rob Verschoor

2005-04-13, 3:24 am

Try:

exec sp_helptext your_proc_name

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<VMI> wrote in message news:425c455a.6abc.1681692777@sybase.com...
> Is it possible to write a Select statement that'll display
> the contents of a specific stored procedure? I'm working
> with SQL Advantage .
>
> Thanks.

wkraatz

2005-04-13, 9:24 am

I have attached a stored procedure to display the source
code for
a stored procedure.

> Is it possible to write a Select statement that'll display
> the contents of a specific stored procedure? I'm working
> with SQL Advantage .
>
> Thanks.

Sponsored Links