Connecting Tech Pros Worldwide Forums | Help | Site Map

db2look option with table create statements only

Justin
Guest
 
Posts: n/a
#1: Nov 1 '07

Is there an option with db2look to create the create tables only?
Looking to keep the primary keys / indexes out of the mix for right
now...


EricDeWerth
Guest
 
Posts: n/a
#2: Nov 1 '07

re: db2look option with table create statements only


On Nov 1, 4:40 pm, Justin <kfw...@hotmail.comwrote:
Quote:
Is there an option with db2look to create the create tables only?
Looking to keep the primary keys / indexes out of the mix for right
now...

You can use [-t Tname1 Tname2...TnameN] or just create the entire
script and use a file filter like SED.

I used SED to split out the tables and primary keys from the foeign
keys so I imagine that you could do the same for PK and Indexes.

Closed Thread