VIEW to COLUMN relation

Document ID : KB000047553
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Where in the CA Repository metamodel is the VIEW to COLUMN relation stored?

 

Answer:

The 'SQL COL' relationship in the DB2 Metamodel relates a VIEW to a COLUMN.   This relation is populated by the DB2 Exchange for views that the scanner can successfully parse.  Complex views with nested and inner joins cannot be parsed by the scanner and thus will not create this relationship.  In these cases, the 'SQL COL' relationship can be established manually or using a generic batch load program such as DBXLOAD.