Hi

I have seen a a tool Development Work Bench (DWB) in ver9
It gives a DDL for procedure
But prob is one by one
See if this helps you out


bye

-----Original Message-----
From: vedant k7
[mailto:db2udbdba-ezmlmshield-x42003445.[Email address protected]
Sent: Tuesday, April 24, 2007 4:02 AM
To: LazyDBA Discussion
Subject: Extract DDL for stored procedures...

What is the best way to extract DDL for all stored procs in a schema?

1. I used db2look command. but it does not let me specify only stored
procedures.
2. Other way is Control Center. But, when I tried to Right-click on a
procedure from Control center, it does not show Extract DDL option in
the
popup menu.

In the help document I found we need "SYSPROC.ADB2RE" stored proc to use

Extract DDL. Does anyone know how I can get these admin procedures in my

database.


Please suggest any straight forward way to accomplish this.


Thanks,

Surendar.

_________________________________________________________________
Catch the complete World Cup coverage with MSN
http://content.msn.co.in/Sports/Cricket/Default.aspx



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.


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