Relationship types

Relationship types are used throughout the Metadata Analyzer. Relationship types include the following:

• Action – A movement or comparison relationship between data item and/or virtual column entities. For example a COBOL MOVE statement creates an Action relationship between data item entities.
• Alias – A relationship between a DB2 table entity and its associated alias or synonym table entities.
• Application Defined – A relationship between virtual column entities or a virtual column and a data item, where the two entities serve as an intersection of virtual tables within a SQL statement.
• Collected – A relationship between a collection and some of its entities.
• Contains – A parent-child type of relationship. For example, a program entity contains data item entities.
• Foreign Key – A database relationship between column entities within DB2, where one column is a foreign key of another column.
• User Defined – A relationship that has been manually added by an Admin user.
• Uses – A relationship where one entity uses another entity. For example, a DBMS instance is Used by a CICS region.