Hey,
Use the below query from db2cmd.
db2 "select text from syscat.routines where routinetype='P' and
routineshcema='ALS'" > CODE.TXT
Use different schema or remove from query..
Regards
Rajesh
-----Original Message-----
From: vedant k7
[mailto:db2udbdba-ezmlmshield-x42003445.[Email address protected]
Sent: Monday, April 23, 2007 6:32 PM
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 is intended only for the personal and confidential use of the designated recipient(s) named above. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communication is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product, an official confirmation of any transaction, or as an official statement of Lehman Brothers. Email transmission cannot be guaranteed to be secure or error-free. Therefore, we do not represent that this information is complete or accurate and it should not be relied upon as such. All information is subject to change without notice.
--------
IRS Circular 230 Disclosure:
Please be advised that any discussion of U.S. tax matters contained within this communication (including any attachments) is not intended or written to be used and cannot be used for the purpose of (i) avoiding U.S. tax related penalties or (ii) promoting, marketing or recommending to another party any transaction or matter addressed herein.
DB2 & UDB email list listserv db2-l LazyDBA home page