Newbie question : show the text of a stored procedure

forum.sourcecode (2000-2005) & forum.td.sourcecode (2005-2010)
Eddy Fontaine

Newbie question : show the text of a stored procedure

Post by Eddy Fontaine » 15 Jun 2009, 19:20

 Posted by:  Eddy Fontaine 

Hi,
I really do not know where to post this :

I am new to SQLBase 9.1, and i would like to
list the text of some stored procedures on
an existing DB, to get some examples...

I have sysadm rights, but can i use SQLTalk for this ?

Thanks,
Eddy.

TerryP
Australia
Posts: 273
Joined: 06 Mar 2017, 22:41
Location: Mackay QLD Australia

Re: Newbie question : show the text of a stored procedure

Post by TerryP » 15 Jun 2009, 23:39

 Posted by:  Terry Phythian 

Hi Eddie,

In SQL Talk, with SYSADM rights, just use the following:

select Text from SysCommands where Name = 'command-name';

Where 'command-name' is the desired command name in upper-case (and in
single quotes).

Cheers,
Terry.

Return to “td.sourcecode”

Who is online

Users browsing this forum: [Ccbot] and 0 guests