GET ROUTINE for a UDF

[sree]

Hi

The following command gives the procedure body in a file a.sql
db2 GET ROUTINE INTO a.sql FROM PROCEDURE <procedure_name>

same way , how do I get the body of a user defined function?

From Control center , we can't see the body of a user defined function as we see the body of a procedure.

I know we can import the UDF using DB2 development center and then see the body of UDF. But DB2 development center is too slow, thats the reason I am asking for a command which will get the UDF body.

Thanks
sree

[f***@yahoo.com]

If the UDF is not created by SQL, then you cannot see the source code. For UDF created by SQL, you can see the codes under functions folder. I use the TOAD for DB2 freeware, which is a piece of cake to view the source.