Hi Kevin,

The definations of stored procedures are stored in system table
syscat.procedures.

U can get it like this

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

Otherwise you can also use get routine/ Put routine for migrating stored
procedures.

db2 " get routine into <filename> from procedure <proce_name>"

And for putting thsi procedute in database

db2 " put routine from <filename> owner <owner_name> "


Hope this will help.

Thanx & Rgds
Deepak Bansal
[Email Address Removed]
"Kevin Chuang" <[Email Address Removed]
To: [Email Address Removed]
cc:
Thursday March 11, 2004 09:06 AM Subject: generate DDL for store procedure






db2look does not generate source code for stored procedure.
any way we can migrate stored procedure easily?


Regards,
Kevin Chuang


-----------------------------------------
This message and its attachments may contain privileged and confidential
information. If you are not the intended recipient(s), you are prohibited
from printing, forwarding, saving or copying this email. If you have
received this e-mail in error, please immediately notify the sender and
delete this e-mail and its attachments from your computer.




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