Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Creating a duplicate table using Platinum Tool

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Aug 21, 2008 12:16 pm    Post subject: Creating a duplicate table using Platinum Tool
Reply with quote

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.
Back to top
View user's profile Send private message

Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Thu Aug 21, 2008 2:33 pm    Post subject: Reply to: Creating a duplicate table using Platinum Tool
Reply with quote

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
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Aug 21, 2008 2:41 pm    Post subject:
Reply with quote

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

Can you just tell me about the term 'SHOP'
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Aug 21, 2008 2:59 pm    Post subject:
Reply with quote

Hi,
sushanth bobby wrote:
Can you just tell me about the term 'SHOP'
"Shop", "Site" etc. are loosly/usually used for the Mainframe "machine" you work on as an employee..

In simple wordings, your Mainframe is "different " than mine in many ways (e.g. system storage rules.. ), to differentiate among all such Mainframes "shop" word is usually used ..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us