How to check schema for housekeeping old CA Gen Host Encyclopedia models

Products

• Gen - Host Encyclopedia

Issue/Introduction

While deleting old models from CA Gen 7.6 Host Encyclopedia (HE), how to view the schema for each model?

 

Environment

Release : 8.6

Component : CA Gen Host Encyclopedia

Resolution

Several ways to see the model schema.

1.One way from the Host Ency is to go to:

     From the main menu 

    Select 1 - Host Encyclopedia functions

    Then 3 - Model management

    And then 5 - Display model statistics   and select a model for display.

    The screen will display several things including the model schema.

 

 

2.Additionally Some SQL to list all models in the last two prior schemas.   

    SELECT MODEL_NAME, MODEL_RELEASE

     FROM DMDL

    WHERE MODEL_RELEASE = '9.1.A5'

          OR MODEL_RELEASE = '9.0.A2' ;

 

Additional Information

Schema and Gen product releases