Creating a duplicate table using Platinum Tool

sushanth bobby · Posted: Thu Aug 21, 2008 12:16 pm

Hi,
I want to create a duplicate table, which must have all the attributes & datatypes of another table except the table name. New table name i will be specifying.

I want to know how to do it using platinum tool, which is what i am using.

There are strategy's here, i was given training on only one strategy that is ALTERATION STRATEGY, i can only alter a table. I think.
Can a new table be created by using alteration strategy ?

I browsed RC/QUERY and went to that table. And type'd CREATE and pressed enter. The next screen was "CA - Table Create". There you can create a new table there, i mean, i have to type in all the column name & data types all the rest of the details. In that case i have to type in nearly 250 column names & details.

HELP ME.

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

What We usually do in our shop to create a table using Platinum is we will create the DDL . Then create a strategy for the particular table using Platinum .Will do a Analysis using the platinum tool and Finally the analysed member which contains the DDL will be applied to a particular region .

Since you want to create a table with same characterstics of the one which exists. You can directly get DDL using the Platinum tool. After getting the DDL just change the table name and apply it in your test region

sushanth bobby · Posted: Thu Aug 21, 2008 2:41 pm

This would do.
Thank You Very Much Prasanth....

Can you just tell me about the term 'SHOP'

Anuj Dhawan · Posted: Thu Aug 21, 2008 2:59 pm

Hi,