Trying to find out how RI (Referential Integrity) information is stored in Gen metadata tables.
Looking at an old Gen online module system where RI is implemented in Gen and everything is statically linked.
To know where a given RI module is called from then one option is to scan source/load libs, but that may not be optimal
Can the same information be extracted from Gen metadata tables (Schema/Data/PI Tables etc.) ?
Also, where is there more information about things like DASC ASSOC_TYPE_CODE, DPRP PROP_TYPE_CODE etc. ?
It's not there in heref HTML help file. Can that information be included in Gen online manuals: HE DATA TABLES
1. In the model, an RI trigger is implemented as an ACBLKTD object plus associated IMPLGIC object: Modifying Referential Integrity Triggers for Migration
Relevant PI tables are CD_ACTN_BLK (Cascade Delete (CD) action block) and IMPLEMENT_LOGIC which can be joined:
Public Interface Table Definitions
Possible Joins in the Public Interface - IMPLEMENT_LOGIC (TD_ACTN_BLOCK should say CD_ACTN_BLOCK)
Using IMPLEMENT_LOGIC for both ACTION_BLOCK & CD_ACTN_BLOCK to match names to IMPLGIC object ids and then using IMPL_LOGIC_USAGE to find those IMPLGIC object ids should reveal what (normal) ACTION_BLOCK calls what (RI) CD_ACTN_BLOCK
Also see "Cascade Delete Support" diagram here: Relationships Between Public Interface Tables
2. The file "%Gen86%\Gen\heref.chm" just contains the definition of the Host Encyclopedia schema and data table columns so just has the same info as the techdocs HE DATA TABLES
For the actual values of object types, association types, property types and their short names/long names, the file odrpta.chm in the same directory has the complete meta-model schema structure.
Using HE utility TIEWENCY in conjunction with odrpta.chm is a good way to learn about the meta-model: Host Encyclopedia Utilities
1. Similar advice applies for CSE Public Interface views: Client Server Encyclopedia Public Interface
Public Interface View Definitions (A-D) - ACTION_BLOCK, CD_ACTN_BLOCK
Public Interface View Definitions (E-L) > View Definitions-I - IMPLEMENT_LOGIC, IMPL_LOGIC_USAGE
2. The file "%Gen86%\Gen\cseref.chm" is the corresponding file for the CSE.
Again, for the actual values of object types, association types, property types and their short names/long names, the file odrpta.chm in the same directory has the complete meta-model schema structure.
Using the CSE utility Walkency in conjunction with odrpta.chm is a good way to learn about the meta-model: Utilities in Support Client