Hi
I am sure tht the compiled procedures are stored in sysibm.sysprocedures.

If i put query over this table(sysibm.sysprocedures), i could able to see
the corresponding procedure.
But i hope a command called GET ROUTINE could be used to retrieve
a compiled procedure into a filename.

But when i use the command
GET ROUTINE into <filename> from PROCEDURE <procedurename>

The command gets executed without any error and some ascii text is
stored in tht file.

How to solve this !!!!

regards
saiprasad

DB2 & UDB email list listserv db2-l LazyDBA home page