CA Gen Client Server Encyclopedia SQL to show HPVP setting by Action Block

Products

• Gen
• Gen - Workstation Toolset
• Gen - Host Encyclopedia
• Gen - 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 Internal or 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;

Additional Information

CA Gen Host Encyclopedia SQL to show HPVP setting by Action Block: https://comm.support.ca.com/kb/requesting-sql-to-show-hpvp-setting-by-ab/KB000128993