Reporting on Gen model information (Host Encyclopedia)

Products

• Gen
• Gen - Host Encyclopedia

Issue/Introduction

How can the different component count information for the contents of a Gen model be extracted from a model residing on the Host Encyclopedia (HE) i.e.

For Database Components:
1) Total Entity Types in Data Model
2) Total Tables in Physical Data Model

For Action Diagram Components:
1) Total Online Procedure Steps
2) Total Client Procedure Steps
3) Total Server Procedure Steps
4) Total Batch Procedure Steps
5) Total External Action Blocks
6) Total Other Action Blocks

For User Interface Components:
1) Total 3270 Screens
2) Total GUI Windows

Resolution

In the HE the Model Contents Report can be run on each model and should be able to provide most of the required information. The alternative is to run SQL against the Host Encyclopedia tables.

1. For the Model Contents Report, the resulting report (default name USERID.IEF.MCRPT) contains specific "OBJECT TYPE" strings to get a count of the specific types of interest. However, that report won't be able to provide counts on the different types of Procedure Steps and SQL will be needed for that.
It is suggested to transfer the report to a Windows machine via ASCII mode for review.
The Windows (DOS) command find can be used to get counts from the file for the required "OBJECT TYPE" strings.
Start a command prompt and run find against the file for the required text string using its "/c" parameter to get the count for that string.
Example for report file named MCRPT.txt after transfer to Windows machine:
**********
For Database Components:
1) Total Entity Types in Data Model
Search for "OBJECT TYPE:      Highest Lvl Analysis Entity Type".
Using the find command:
===
find /c "OBJECT TYPE:      Highest Lvl Analysis Entity Type" MCRPT.txt

---------- MCRPT.TXT: 134
===

2) Total Tables in Physical Data Model
Search for "OBJECT TYPE:      Data Record"
Using the find command:
===
find /c "OBJECT TYPE:      Data Record" MCRPT.txt

---------- MCRPT.TXT: 134
===
Both of the above being the same value would typically occur if each entity type in the logical data model has already been transformed to a corresponding physical table/data record.

For Action Diagram Components:
1-4 below are included in the search for "OBJECT TYPE:      Procedure Step  "
Using the find command:
===
find /c "OBJECT TYPE:      Procedure Step  " MCRPT.txt

---------- MCRPT.TXT: 357
===
NOTE: 2 spaces are required after the word Step for an accurate search because there is another object type "OBJECT TYPE:      Procedure Step Execution Usage" in the report.

1) Total Online Procedure Steps
2) Total Client Procedure Steps
3) Total Server Procedure Steps
4) Total Batch Procedure Steps
5) Total External Action Blocks
Search for: "Internal/External indicator      E"
Using the find command:
===
find /c "Internal/External indicator      E" MCRPT.txt

---------- MCRPT.TXT: 120
===

6) Total Other Action Blocks
Search for: "OBJECT TYPE:      BAA Action Block"
Using the find command:
===
find /c "OBJECT TYPE:      BAA Action Block" MCRPT.txt

---------- MCRPT.TXT: 60
===

Search for: "OBJECT TYPE:      BSD Action Block"
Using the find command:
===
find /c "OBJECT TYPE:      BSD Action Block" MCRPT.txt

---------- MCRPT.TXT: 831
===
NOTE: BSD Action blocks also include Procedure Step Action Blocks so to get the true number of "other" BSD Action Blocks requires subtracting the Procedure Step total.
So the total net number of "other" BSD Action Blocks = 60+831-357 = 534

For User Interface Components:
1) Total 3270 Screens
Search for: "OBJECT TYPE:      Screen  "
Using the find command:
===
find /c "OBJECT TYPE:      Screen  " MCRPT.txt

---------- MCRPT.TXT: 152
===
NOTE: 2 spaces are required after the word Screen for an accurate search because there is another object type "OBJECT TYPE:      Screen Literal" in the report.

2) Total GUI Windows
Search for: "OBJECT TYPE:      Window Primary (primary window)"
Using the find command:
===
find /c "OBJECT TYPE:      Window Primary (primary window)" MCRPT.txt

---------- MCRPT.TXT: 15
===

Search for: "OBJECT TYPE:      Dialog Box"
Using the find command:
===
find /c "OBJECT TYPE:      Dialog Box" MCRPT.txt

---------- MCRPT.TXT: 0
===
**********


2. If using SQL is the preferred option, Support also provided the attached file sql_examples.txt which contains SQL statements to get all the required data. Per the above, to provide counts on the different types of Procedure Steps SQL will be required for that.
Where possible SQL is provided to run against either the HE (raw) Data Tables or the Public Interface (PI) Tables, but in some cases, only the raw Data Table SQL can be used.
The use of SQL against the Public Interface Tables assumes the model has already been exported to the PI (Public Interface Export Function).