ddl extraction

rashmi.ranjan75 · New User Joined: 20 Feb 2006 Posts: 34

hi,

could somebody tell me how to extract ddls of tables from db2 on mainframes.

thanks in advance

regards
rashmi

ragshere · New User Joined: 20 Dec 2004 Posts: 70

Hi rashmi,
In IBM , you can use ADBGEN utility. there are different tools in different companies for DDL extraction.

Thanks
Rags

venky5436 · New User Joined: 06 Dec 2005 Posts: 12

Extract DDL in DB2 on Unix use db2look

No idea about mainframes.

astro · New User Joined: 08 Mar 2006 Posts: 3

One quick way in mainframes: if you have access to ADBL(DB2 Administration Tool Set ) utility, after selecting the required table, You can type ddl in the command line and press Enter key to get the ddl of that table.

martin9 · Posted: Fri Mar 17, 2006 6:28 pm

hy rashmi,

how you want to extract the ddl,
in batch or online?
in online: go to the db2 administrator from
ispf primary option menu, choose option g.d.2.a
and before any object like table, tablespace, database....
you can type the line command ddl. the dialog will
extract this or at least will generate a job which will
do this. save that job for the next time so you can
use it also in batch....

martin9

rashmi.ranjan75 · New User Joined: 20 Feb 2006 Posts: 34

thanks for your inputs

regards
Rashmi