CA Gen Client Server Encyclopedia SQL to show HPVP setting by Action Block
book
Article ID: 129204
calendar_today
Updated On:
Products
GenGen - Workstation ToolsetGen - Host EncyclopediaGen - Run Time Distributed
Issue/Introduction
It can be useful to know which Action Block in a CA Gen model have High Performance View Passing (HPVP) enabled or otherwise (by default newly created Action Blocks have HPVP enabled). The SQL provided below is valid for the CA Gen Client Server Encyclopedia (CSE).
Environment
CA Gen Client Server Encyclopedia (CSE)
Resolution
High Performance View Passing (HPVP) is controlled by the Action Block property PASSGLOB which for a CSE is stored in DOBJ table column OBJ_CHAR_PROP_4. If the value of the property is 'M' then HPVP is enabled. If the value of the property is 'Y' or ' ' then HPVP is disabled. (NOTE: Since the HPVP feature was added any new action blocks created where HPVP is disabled will have PASSGLOB='Y'. However very old action blocks created before the HPVP feature was added will have PASSGLOB=' ')
NOTE: In the below SQL the additional property OBJ_CHAR_PROP_1 will also indicate whether the Action Block is Internalor External.
1. List all action blocks within a model with HPVP enabled. SELECT OBJ_ID, OBJ_NAME, OBJ_CHAR_PROP_1, OBJ_CHAR_PROP_4 FROM DOBJ, DMDL WHERE MODEL_NAME = 'your model name' AND MODEL_ID = OBJ_MODEL_ID AND OBJ_TYPE_CODE IN (21,23) AND OBJ_CHAR_PROP_4 = 'M' ORDER BY OBJ_NAME;
2. List all action blocks within a model with HPVP disabled: SELECT OBJ_ID, OBJ_NAME, OBJ_CHAR_PROP_1, OBJ_CHAR_PROP_4 FROM DOBJ, DMDL WHERE MODEL_NAME = 'your model name' AND MODEL_ID = OBJ_MODEL_ID AND OBJ_TYPE_CODE IN (21,23) AND OBJ_CHAR_PROP_4 != 'M' ORDER BY OBJ_NAME;