db2look command ?
How do I use this ?

db2look is used to extract the DDL and other informations.it has many options , read it in

IBM® DB2® Universal Database
Command Reference


regards,

Mujeeb

Hi,

You can also use:
db2look ?
on DB2 Command Window to see the help.

Grofaty

from command line processor, to get the ddl of a table, issue the following command, modifying the parameters in capslock.(username and password is the one you use connecting to the database)

>db2look -d YOUR_DATABASENAME -t YOUR_TABLENAME -a -e -l -x -c -o ddl.out -i YOUR_USERNAME -w YOUR_PASSWORD