March 1, 2010 at 3:53 pm
I am modeling a database which uses the same column multiple times throughout many tables, ex there is a timestamp field in every table and I’d like to add the comment 'records last modified date' as a comment each time this field is used...any suggestions?
March 3, 2010 at 10:51 am
Are you saying that you want a single table that holds
TableName, DateLastModified
If so, then one way would be to add a trigger to every table that you require to be logged to create or update the record in the LastUpdate table.
March 4, 2010 at 10:19 am
If you are talking about adding comments in ERwin when you add the audit column(s) to a table (or to update comments where the columns already exist), there are a few options:
Copy the column(s) from one table to another (ERwin 7.x). Highlight the column in the table you want to copy from, holding the 'CTRL' key down while dragging it to the new table. The comment will copy with all of the other column info.
Check out this article from InfoAdvisors on how to mass import definitions into ERwin:
http://www.infoadvisors.com/ArticlesVideos/MassImportofDefinitionsinERwin/tabid/159/Default.aspx
You can also use the ERwin API to import definitions. Use your CA site ID to log in and search the knowledge base for the API Reference Guide and presentations on how to use the API.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply