Off Topic ERwin Question

Dave Nance

Off Topic ERwin Question
    Ok, I know this isn't really one of the topics we cover on here, but I have
asked in a couple of other forums last week and had no response as yet. And, I
know how great everyone on our list-serv here is at having an answer for
someone, so let's hear for DB2-L.
 
   I just recently took over as architect for a company and inherited 15 or
so models in ERwin(All fusion) that should really be one model with a bunch of
subject areas. I can, tediously, but easily copy each of them into a model as a
subject area. The problem I am having is that each of these models uses their
own individual naming file. These naming files change the names of tables and
columns to reflect some standard. I am attempting to find some way of saving the
individual models, so that the naming file is no longer needed when viewing the
model, meaning save the changed names. Any suggestions would be greatly
appreciated. Thanks.

 
David Nance




_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Dave Petronella

Re: Off Topic ERwin Question
(in response to Dave Nance)
I got this reply from one of our DAs. I see that the Name Hardening
feature is on both the Logical and Physical side, under the Tools/Names
Menu. I suspect you want only the physical names kept.

Hope this helps.


Using Erwin, there is a feature called Name Hardening.
This can be used to freeze any existing physical names.

You will need to open model and then name harden everything.
Then complete compare and import the next model as is and harden those
names also.

When you have completed this for all five models, then you can update the
naming standards file that you want to use globally for this 1 new model
going forward




________________________
David Petronella
Vice President
Data Resource Management / DB2 Database Administration
Pershing LLC, a BNY Mellon company
www.pershing.com
Office: (973) 360-7747
Fax: (973) 360-3121
Email: [login to unmask email]

Go Green. Think before you print.



From: Dave Nance <[login to unmask email]>
To: [login to unmask email]
Date: 12/06/2010 12:08 PM
Subject: [DB2-L] Off Topic ERwin Question
Sent by: IDUG DB2-L <[login to unmask email]>



Ok, I know this isn't really one of the topics we cover on here, but I
have asked in a couple of other forums last week and had no response as
yet. And, I know how great everyone on our list-serv here is at having an
answer for someone, so let's hear for DB2-L.

I just recently took over as architect for a company and inherited 15
or so models in ERwin(All fusion) that should really be one model with a
bunch of subject areas. I can, tediously, but easily copy each of them
into a model as a subject area. The problem I am having is that each of
these models uses their own individual naming file. These naming files
change the names of tables and columns to reflect some standard. I am
attempting to find some way of saving the individual models, so that the
naming file is no longer needed when viewing the model, meaning save the
changed names. Any suggestions would be greatly appreciated. Thanks.


David Nance




The IDUG DB2-L Listserv is only part of your membership in IDUG. If you
are not already an IDUG member, please register here.


******************************************************
IMPORTANT: Any information contained in this communication is intended for the use of the named individual or entity. All information contained in this communication is not intended or construed as an offer, solicitation, or a recommendation to purchase any security. Advice, suggestions or views presented in this communication are not necessarily those of Pershing LLC nor do they warrant a complete or accurate statement.

If you are not an intended party to this communication, please notify the sender and delete/destroy any and all copies of this communication. Unintended recipients shall not review, reproduce, disseminate nor disclose any information contained in this communication. Pershing LLC reserves the right to monitor and retain all incoming and outgoing communications as permitted by applicable law.

Email communications may contain viruses or other defects. Pershing LLC does not accept liability nor does it warrant that email communications are virus or defect free.
******************************************************

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Dave Nance

Re: Off Topic ERwin Question
(in response to Dave Petronella)
Sorry, would have responded sooner, but had to get a new laptop and download
ERwin prior to trying out.


    This worked like a charm!!! Thanks so much Dave. The DB2-L community comes
through once again when others did not!
 
Dave Nance




________________________________
From: Dave Petronella <[login to unmask email]>
To: [login to unmask email]
Sent: Mon, December 6, 2010 1:40:49 PM
Subject: Re: [DB2-L] Off Topic ERwin Question


I got this reply from one of our DAs.  I see that the Name Hardening feature is
on both the Logical and Physical side, under the Tools/Names Menu.  I suspect
you want only the physical names kept.


Hope this helps.


Using Erwin, there is a feature called Name Hardening.
This can be used to freeze any existing physical names.
 
You will need to open  model and then name harden everything.
Then complete compare and import the next model as is and harden those names
also.

 
When you have completed this for all five models, then you can update the naming
standards file that you want to use globally for this 1 new model going forward





________________________
David Petronella
Vice President
Data Resource Management / DB2 Database Administration
Pershing LLC, a BNY Mellon company
www.pershing.com
Office: (973) 360-7747
Fax: (973) 360-3121
Email: [login to unmask email]

Go Green. Think before you print.



From:        Dave Nance <[login to unmask email]>
To:        [login to unmask email]
Date:        12/06/2010 12:08 PM
Subject:        [DB2-L] Off Topic ERwin Question
Sent by:        IDUG DB2-L <[login to unmask email]>
________________________________



    Ok, I know this isn't really one of the topics we cover on here, but I have
asked in a couple of other forums last week and had no response as yet. And, I
know how great everyone on our list-serv here is at having an answer for
someone, so let's hear for DB2-L.

 
   I just recently took over as architect for a company and inherited 15 or so
models in ERwin(All fusion) that should really be one model with a bunch of
subject areas. I can, tediously, but easily copy each of them into a model as a
subject area. The problem I am having is that each of these models uses their
own individual naming file. These naming files change the names of tables and
columns to reflect some standard. I am attempting to find some way of saving the
individual models, so that the naming file is no longer needed when viewing the
model, meaning save the changed names. Any suggestions would be greatly
appreciated. Thanks.



David Nance



________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not
already an IDUG member, please register here.

******************************************************
IMPORTANT: Any information contained in this communication is intended for the
use of the named individual or entity. All information contained in this
communication is not intended or construed as an offer, solicitation, or a
recommendation to purchase any security. Advice, suggestions or views presented
in this communication are not necessarily those of Pershing LLC nor do they
warrant a complete or accurate statement.


If you are not an intended party to this communication, please notify the sender
and delete/destroy any and all copies of this communication. Unintended
recipients shall not review, reproduce, disseminate nor disclose any information
contained in this communication. Pershing LLC reserves the right to monitor and
retain all incoming and outgoing communications as permitted by applicable law.

Email communications may contain viruses or other defects. Pershing LLC does not
accept liability nor does it warrant that email communications are virus or
defect free.
******************************************************


________________________________

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not
already an IDUG member, please register here.





_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv