db2look

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Asphalt Blazer - 26 Jun 2006 20:35 GMT

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

Reply to this Message

Shashi Mannepalli - 26 Jun 2006 21:24 GMT

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

> 1. How can I generate sql file for just stored procedure statements
> using db2look
[quoted text clipped - 3 lines]
>
> any help welcome. thanks

Reply to this Message

Serge Rielau - 26 Jun 2006 21:43 GMT

> 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.

???

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

Shashi Mannepalli - 27 Jun 2006 02:51 GMT

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..

/

Reply to this Message