user defined functions

Database

user defined functions

Hi,

The following query worked to fetch the source code for a stored procedure in teradata:

SHOW PROCEDURE User.Age_Calc;
(User.Age_Calc is name of the procedure)

But this does not work for showing a user defined function:
SHOW FUNCTION ;

How can I view the source code for a user defined function?
1 REPLY
N/A

Re: user defined functions

Of course it works, so the actual error code/message would be helpful.

You probably got an overloaded function, thus you have to write
SHOW SPECIFIC FUNCTION ....

Dieter