sai

try out this you will get your stored procedure code,


db2 " export to <proc_name.db2> of del select text from syscat.procedure
where procname=<proc_name> and procschema=<proc_schema> "


get routine to extract , use put rountine to import it another database



Thanks and Regards
Rajesh Swaminathan
DBA -TEAM OMT/SIGS/ACG/BRS/CD/BDT - IDEAS
OFF : 813-978-2258
PAGER:813-706-5804


|---------+--------------------------------------------------------->
| | "SaiPrasad" |
| | <db2udbdba-ezmlmshield-x75369486.[Email Address Removed] | azydba.com> |
| | |
| | 10/26/2004 08:32 AM |
| | |
|---------+--------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: How to retrieve a compiled Procedure |
>----------------------------------------------------------------------------------------------|




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


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







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