469,962 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,962 developers. It's quick & easy.

db2look

1. How can I generate sql file for just stored procedure statements
using db2look
2. while using db2 look with just the -tw option my file is always
coming out as a ps file even though i used -0 db2look.sql with it. What
is the reason for this?

any help welcome. thanks

Jun 26 '06 #1
3 2360
U need specify -e option.
And for SP's it will only give the BODY...for full text u need to
select them
from SYSCAT.PROCEDURES.

cheers...
Shashi Mannepalli
Asphalt Blazer wrote:
1. How can I generate sql file for just stored procedure statements
using db2look
2. while using db2 look with just the -tw option my file is always
coming out as a ps file even though i used -0 db2look.sql with it. What
is the reason for this?

any help welcome. thanks


Jun 26 '06 #2
Shashi Mannepalli wrote:
U need specify -e option.
And for SP's it will only give the BODY...for full text u need to
select them
from SYSCAT.PROCEDURES.

???

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jun 26 '06 #3
Sorry...not clear....

This was tested... SQL stored procedures...

db2look -d xxxx -e -a -nofed -noview -u xxxx -i all.ddl

Easy way to do is...select text from syscat.procedures...

cheers..

/

Jun 27 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by dbtoo_dbtoo | last post: by
6 posts views Thread by Lennart Jonsson | last post: by
1 post views Thread by Lyn Duong | last post: by
1 post views Thread by db2group88 | last post: by
8 posts views Thread by db2sysc | last post: by
2 posts views Thread by shsandeep | last post: by
1 post views Thread by Gregor Kovańć | last post: by
2 posts views Thread by Justin | last post: by
1 post views Thread by blaisestephen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.