table ddl generation

toby25 · #1 (**permalink**) 04-28-04, 12:21

I want to generate ddl information of all tables created on tablespace USERSPACE1. Is there any way to do so?

Thanks in advance
toby

hanyheggy · #2 (**permalink**) 04-28-04, 12:24

check db2look tool it have all options to generate DDL on database level ot tablesapce level

toby25 · #3 (**permalink**) 04-29-04, 11:22

Whats the option in db2look to generate table DDLs on a specific tablespace?

Thanks in advance

sathyaram_s · #4 (**permalink**) 04-29-04, 11:29

None, AFAIK ...

You may want to use grep -p <Tablespace name>

This is what I do

Cheers
Sathyaram