Home > Archive > SQL Anywhere database > May 2005 > Searching stored procs









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Searching stored procs
Doug

2005-05-13, 11:23 am

We are using Sybase Central Java Version 4.0.0.290 to access our ASA
7.0.0.313 database. This database has many lengthy stored procedures.

I'd sure like to be able to do a search through all the stored procedures.
Can I do that with Syabse Central or do I need a more feature-rich database
development tool?


Joshua Savill

2005-05-13, 1:23 pm

Doug,

Not sure exactly what you are searching for in the stored procedures, but
there are two things you can do to look at the stored procedures. In Sybase
Central you can view all the stored procedures created in the database. Make
sure you "Filter Objects by Owner" to see all the procedures.

The other option is do an unload of the database schema (dbunload -n). This
will include all of the structures and procedures. The reload.sql file that
is created by unloading the schema can be opened in a text editor.

HTH
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Doug" < doogie414removethis@
yahoo.com> wrote in message
news:4284c74a$1@foru
ms-2-dub...
> We are using Sybase Central Java Version 4.0.0.290 to access our ASA
> 7.0.0.313 database. This database has many lengthy stored procedures.
>
> I'd sure like to be able to do a search through all the stored procedures.
> Can I do that with Syabse Central or do I need a more feature-rich
> database
> development tool?
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com