Let's say I have a DB2 database full of objects (tables, constraints, views, stored procedures and triggers) all belonging to the same custom schema.
I would like to know if it is possible to generate a sql script with all these objects.
In SQl Server exists an options named "generate sql script". WIth this options it is possible to generate a script by which I can create the database everywhere I want (I mean the objects structure not the data of course). Is it possible to do this in DB2?
The script may look like this one:

Create table T1 ...
Create table T2 ...
Create table T3 ...
...
Create index I1
Create index I2
etc
Alter table T1 add constraint FK ...

Create trigger tg1

etc.

Thanks in advanced.

See if the db2look utility will help you. Its detailed description is in the Command Reference

Hi there

I think db2look utility will help you out

But you may not be able to generate dll for Stored Procedures from db2look utility



Regards