How to create a Client Server Encyclopedia (CSE) report of Model Entity Types that do not have any Relationships?

book

Article ID: 38088

calendar_today

Updated On:

Products

CA Gen CA Gen - Build Tool CA Gen - Workstation Toolset CA Gen - Host Encyclopedia CA Gen - Run Time Distributed 3RD PARTY TSO

Issue/Introduction

Question:

How to create a Client Server Encyclopedia (CSE) report of Model Entity Types that do not have any Relationships? 

 

Answer:

1. Using the CSE Encyclopedia Client run a Object Cross Reference Report on the model, selecting Report Type of "Contains" and then select all the Entity Types in the model. That will include Relationships where they exist so  the report can be manually scanned for Entity Types that do not have any. For further details please see the "Using the Client Server Encyclopedia" -> "Encyclopedia Reports": CSE Object Cross-Reference Reports

2. Alternatively SQL can be used and for each relationship in the model the CSE Public Interface view RELATIONSHIP contains 2 rows representing each direction of the relationship. This SQL can be run to join the PI views ENTITY_TYPE, RELATIONSHIP & MODEL to build a list of Entity Types for a particular model that are not used in any relationship e.g. 

select E.NAME from ENTITY_TYPE E, MODEL M 

where M.NAME='TEST1' 

and E.MODEL_ID=M.ID 

and E.ID not in (select SOURCE_ENTITY_ID from RELATIONSHIP);

For further details please see the "Client Server Encyclopedia Public Interface Guide": Client Server Encyclopedia Public Interface

Environment

Release: KGNCRK05500-7.6-Gen-CLS Runtime Kit-for Unisys
Component: