|
View previous topic :: View next topic
|
| Author |
Message |
ssowmya
New User
Joined: 10 Oct 2006
Posts: 40
|
|
|
|
Hi
Could anyone please let me know how we can generate DDL for existing DB2 tables? We have Fileaid for DB3 in our shop....
Please do help
Cheers
Sowmya |
|
| Back to top |
|
 |
amitava
Warnings : 1
Active User
Joined: 30 Oct 2005
Posts: 186
Location: India
|
|
|
|
| Do you have BMC for DB2? Then go to BMC. Provide option 2. Then specify the table name. It will specify the table details i.e the table name, tablespace and other details. Just before the table name write ddl and press Enter. It will show you the DDL of the table you have specified. |
|
| Back to top |
|
|
ssowmya
New User
Joined: 10 Oct 2006
Posts: 40
|
|
|
|
Thank You....It worked for me....  |
|
| Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006
Posts: 310
|
|
|
|
| Can I know What is BMC. please someone explain me.. |
|
| Back to top |
|
|
amitava
Warnings : 1
Active User
Joined: 30 Oct 2005
Posts: 186
Location: India
|
|
|
|
| BMC is a Software Administrative Products for DB2. You can load and extract DB2 data; view or use any DB2 objects. Its a very good software to handle with DB2. |
|
| Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006
Posts: 310
|
|
|
|
| Thanks Amitava. |
|
| Back to top |
|
|
siva001
New User
Joined: 12 Jan 2007
Posts: 9
Location: chennai
|
|
|
|
hi,
if u use platinum tool
in these tool we have to go option 2
there creating stratatey for tablespace,table,index,view,alias,sysnanioms
bye
shiva |
|
| Back to top |
|
|
|
|
