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


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