Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Any DB2/UDB V8 Users?
Topic Summary: How in the world do you generate an ALTER ADD statement now?
Created On: 27-Feb-2006 17:01
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 27-Feb-2006 17:01
User is offline View Users Profile Print this message


Jane Stevens

Posts: 17
Joined: 21-Feb-2006

Version 10.3 has a completely new interface for generating an ALTER ADD statement when using DB2 / UDB version 8.  I'm trying to figure out how we can do this and its not intuitive at all.  When I used Compare and Sync, I ended up w/database connection errors.  I then generated SQL for the entire table and then compared it to the table in the d/base.  Every line is out of sync per the tool and I can't find a way to create the ALTER ADD statement.  We do more alter adds here than we do creates so this is VERY awkward.  Anyone else have any ideas?  I have sent a note to Support asking for help on how to do this.  The HELP file does not explain how to do this at all. 
Report this to a Moderator Report this to a Moderator
 28-Feb-2006 22:07
User is offline View Users Profile Print this message


Jane Stevens

Posts: 17
Joined: 21-Feb-2006

We got the news from SA, 14 steps now to perform an ALTER ADD whereas we used to do this in just a couple of steps.  We're thrilled  
Report this to a Moderator Report this to a Moderator
 2-Mar-2006 20:35
User is offline View Users Profile Print this message


lou varveris

Posts: 32
Joined: 18-Jun-2005

Hi Jane,

As I remember it, it used to be done as follows for DB2 -- there was a property on a column called Alter Add; it was a boolean checkbox. If you toggled that on, when you ran schema generator, one of the options in schema generator that you could select was Alter Add. If you chose that selection, Alter Adds were generated for any columns in your model for which the Alter Add property had been toggled on. The problem with this approach was that if a user decided at generation time to specify columns to generate Alter Adds for, they needed to go into the physical data model, open up those columns, and toggle on the Alter Add property.

Now that DB2 is supported through DB Synchronize (starting in version 10.3 of SA), the interface for generating Alter Adds is completely different, as you have found out. Now, you don't need to go into the physical data model and toggle on a property. When you run DB Synchronize, which compares your physical data model with your database or DDL file, you will get red un-equal signs in the side-by-side compare dialog for all tables in the physical model that are different in the database or DDL file. You can click on the + mark to expand each table to see what columns are different. If you see a column on the data model side with a red unequal sign next to it, it is a column that is not in the target database or DDL file. Simply right-mouse click on it to select it to generate an Alter Add (Alter Table, Add Column) statement. The red unequal sign will be replaced with a black right-hand facing arrow. I am hoping that this is how tech support told you to specify Alter Adds. But I wouldn't count it as 14 steps so I'm hoping they didn't tell you something different.

In any case, we feel that this is an easier way to generate Alter Adds than the previous method. We designed it based on user feedback and also patterned it after other leading data modeling tools on the market. (Some users complained about our older technique.)

But if this method continues to get in your way, ie you can't get used to it, it is like tieing a hand behind your back, etc, let us know and we'll figure some way to make it better.

Lou
Report this to a Moderator Report this to a Moderator
 2-Mar-2006 21:04
User is offline View Users Profile Print this message


Jane Stevens

Posts: 17
Joined: 21-Feb-2006

We actually preferred the older method since we are pressed to deliver database changes ASAP here (as most organizations we are under scrutiny to reduce our development time for the Business).  I see value in the new process, however within our organization we just generate the database change and our DBAS manage all the physical stuff (index naming, identity sequence definition, etc.).  Since we don't generate alot of the physical information the tool is likely going to list more differences than really exist.  We have asked SA to allow us to do either and they have put it in as an enhancement request.  For now, I've taken the 14 steps which Telelogic Support provided and have distributed to our Modelers so that when we move to version 10.3 they have the steps.  Thanks for your input.     
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.