Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: db2look
0 views
Skip to first unread message
Message has been deleted
Shashi Mannepalli
Jun 26, 2006, 4:24:54 PM6/26/06
to
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
Serge Rielau
Jun 26, 2006, 4:43:25 PM6/26/06
to
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.
???> 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/ondemandbusiness/conf2006/
Shashi Mannepalli
Jun 26, 2006, 9:51:13 PM6/26/06
to
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..
/
0 new messages