Newbie question : show the text of a stored procedure

forum.sourcecode (2000-2005) & forum.td.sourcecode (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Newbie question : show the text of a stored procedure

Post by NewsgroupServer » 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.

NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

Newbie question : show the text of a stored procedure

Post by NewsgroupServer » 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 [Crawler] and 0 guests