Set rstRel = Nothing
Set rstPar = Nothing
Set rstChild = Nothing
Set cmd = Nothing
MsgBox "Relationship Metadata has been Imported"
End Function
174 CHAPTER TEN Populating Relationship and Subtype Data in the Repository
䊏
A relationship name is created. It consists of the parent entity name followed
by “has”, followed by the child entity name.
䊏
REL_RELATIONSHIP_M and RKEY_RELKEYATT_M are then updated.
Updating Column Information
Chapter 9 described how the Column entity (table COL_COLUMN_M) can be
enhanced so it can capture information on foreign keys. This information is derived
from the relationship metadata imported from the data model. Listing 10.2
shows how COL_COLUMN_M is updated using the metadata imported into
Relationship (REL_RELATIONSHIP_M