Problem in AIX and almost certainly Windoze too: you can only manipulate the
first 8 Kb or so, selecting direct from the CLOB in the catalog and
directing into a file. So you're forced to db2look. As an aside, there's a
bugette with db2look in this respect. It only started capturing SPs
correctly from V8 FP8 or thereabouts. However at FP13 it reports the create
procedure statement BEFORE the create statements for objects referenced in
the procedure. Unless someone knows smarter? What I do is to run an awk
script around a db2look output for the schema containing the procedure.
Regards
Alex Levy
http://www.sustainablesoftware.net
-----Original Message-----
From: RAJESH CHANDRAMOHAN
[mailto:db2udbdba-ezmlmshield-x26700796.[Email address protected]
Sent: 23 April 2007 23:40
To: LazyDBA Discussion
Subject: RE: Extract DDL for stored procedures...
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.
---------------------------------------------------------------------
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
DB2 & UDB email list listserv db2-l LazyDBA home page