SQL Queries - CAST Knowledge Base - Queries on objects - How to list the objects belonging to an Analysis Unit

Purpose of Query

To find out the list of objects belonging to an analysis unit (View analysis unit content).

The query used is different for versions prior to 8.2 and after 8.2.

Please note that this query uses both CAST Knowledge Base AND CAST Management Base

Applicable CAST Version

Release	Yes/No
8.2.x
8.1.x
8.0.x
7.3.x

Observed on RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

Query for CSS for 8.2 and higher

SELECT mau.object_id   AS "Analysis Unit ID", 
       mau.object_name AS "Analysis Unit Name", 
       pso.object_id   AS "Object ID", 
       k.keynam        AS "Object name", 
       t.typnam        AS "Type" 
FROM   <MNGT>.maint_analysisunits mau 
JOIN   <MNGT>.cms_dynamicfields cdf 
ON     cdf.object_id = mau.object_id 
AND    cdf.field_guid = 'entry' 
JOIN   <LOCAL>.pmc_subsets ps 
ON     ps.subset_name = 'CMS_AU_FULL__' 
              || cast(cdf.field_value AS varchar) 
JOIN   <LOCAL>.pmc_subset_objects pso 
ON     pso.subset_id = ps.subset_id 
JOIN   <LOCAL>.keys k 
ON     k.idkey = pso.object_id 
JOIN   <LOCAL>.typ t 
ON     t.idtyp = k.objtyp 
WHERE  mau.object_name = <YOUR_AU_NAME>

Query result example

12598;"Server";4228002;"_Server_18d71674_";"JV_PROJECT"
12598;"Server";106011;"<Default Package>";"JV_PACKAGE"
12598;"Server";2678661;"Server";"CAST_Web_Directory"
12598;"Server";2678662;"Interface";"CAST_Web_Directory"
12598;"Server";2678660;"WEB-INF";"CAST_Web_Directory"
12598;"Server";4228001;"Server_18d71674";"JSP_APP"
12598;"Server";4228003;"web.xml";"JSP_APPDESCRIPTOR"
12598;"Server";5130777;"applicationScope";"JSP_ATTRIBUTES_SCOPE"
12598;"Server";5130771;"singletonScope";"JSP_ATTRIBUTES_SCOPE"
12598;"Server";5130772;"sessionScope";"JSP_ATTRIBUTES_SCOPE"
[...]

Query result interpretation

All the listed objects belong to Analysis Unit "Server"

Query for CSS before 8.2

SELECT mau.object_id   AS "Analysis Unit ID", 
       mau.object_name AS "Analysis Unit Name", 
       pso.object_id   AS "Object ID", 
       k.keynam        AS "Object name", 
       t.typnam        AS "Type" 
FROM   <MNGT>.maint_analysisunits mau 
JOIN   <LOCAL>.pmc_subsets ps 
ON     ps.subset_name = 'CMS_AU_FULL__' 
              || cast(mau.object_id AS varchar) 
JOIN   <LOCAL>.pmc_subset_objects pso 
ON     pso.subset_id = ps.subset_id
JOIN   <LOCAL>.keys k
ON     k.idkey = pso.object_id
JOIN   <LOCAL>.typ t
ON     t.idtyp = k.objtyp
WHERE  mau.object_name = <YOUR_AU_NAME>

Query result example

3464;"Technical-support";386453;"S:\SOURCES\XXXXXXXXXX";"COBOL_ROOTDIRECTORY"
3464;"Technical-support";386462;"COPYBOOKS";"CAST_COBOL_Directory"
3464;"Technical-support";386463;"XXST0QBL";"CAST_COBOL_Copybook"
3464;"Technical-support";386464;"XXST0NQV";"CAST_COBOL_Copybook"
3464;"Technical-support";386465;"XXST0NQS";"CAST_COBOL_Copybook"
3464;"Technical-support";386466;"XXST0NQR";"CAST_COBOL_Copybook"

[...]

Query result interpretation

All the listed objects belong to Analysis Unit "Technical-support"

Query for Oracle

For CAST AIP 8.2 and above

SELECT mau.object_id   AS "Analysis Unit ID",
       mau.object_name AS "Analysis Unit Name",
       pso.object_id   AS "Object ID",
       k.keynam        AS "Object name",
       t.typnam        AS "Type"

FROM   <MNGT>.maint_analysisunits mau
JOIN   <MNGT>.cms_dynamicfields cdf
ON     cdf.object_id = mau.object_id
AND    cdf.field_guid = 'entry'
JOIN   <LOCAL>.pmc_subsets ps
ON     ps.subset_name = 'CMS_AU_FULL__'
              || cast(cdf.field_value AS varchar(50))
JOIN   <LOCAL>.pmc_subset_objects pso
ON     pso.subset_id = ps.subset_id
JOIN   <LOCAL>.keys k
ON     k.idkey = pso.object_id
JOIN   <LOCAL>.typ t
ON     t.idtyp = k.objtyp
WHERE  mau.object_name = <YOUR_AU_NAME>

Query result example

Analysis Unit ID	Analysis Unit Name	Object ID	Object name	Type
66238	M01	11256	BOE0B336	CAST_COBOL_SavedProgram
66238	M01	11257	M01_66238	COBOL_PROJECT
66238	M01	11259	BOE0TA04	CAST_COBOL_Copybook
66238	M01	11260	Unknown	COBOL_ROOTDIRECTORY
66238	M01	11261	Copybooks	CAST_COBOL_Directory
66238	M01	11262	ROUCABND	CAST_COBOL_Copybook
66238	M01	11263	LCC0CCAM	CAST_COBOL_Copybook

Query result interpretation

All the listed objects belong to Analysis Unit " M01"

For CAST AIP versions before 8.2

SELECT mau.object_id AS "Analysis Unit ID",mau.object_name AS "Analysis Unit Name",
 pso.object_id AS "Object ID",
 k.keynam AS "Object name",
 t.typnam AS "Type"
 FROM <MNGT>.maint_analysisunits mau
 JOIN <LOCAL>.pmc_subsets ps
 ON ps.subset_name = 'CMS_AU_FULL__'
 || cast(mau.object_id AS varchar(50))
 JOIN <LOCAL>.pmc_subset_objects pso
 ON pso.subset_id = ps.subset_id
 JOIN <LOCAL>.keys k
 ON k.idkey = pso.object_id
 JOIN <LOCAL>.typ t
 ON t.idtyp = k.objtyp
 WHERE mau.object_name = <YOUR_AU_NAME>

Query result example

Analysis Unit ID	Analysis Unit Name	Object ID	Object name	Type
66239	M00	14239	CONTROLLA-ERRORE-EX	CAST_COBOL_SavedParagraph
66239	M00	14240	GESTIONE-ERRORE	CAST_COBOL_SavedSection
66239	M00	14241	GESTIONE-ERRORE-EX	CAST_COBOL_SavedParagraph
66239	M00	14242	GESTIONE-ERRORE-WEB	CAST_COBOL_SavedSection
66239	M00	14243	GESTIONE-ERRORE-WEB-EX	CAST_COBOL_SavedParagraph
66239	M00	14244	INVIA-PARAMETRI-WEB	CAST_COBOL_SavedSection
66239	M00	14245	INVIA-PARAMETRI-WEB-EX	CAST_COBOL_SavedParagraph
66239	M00	14246	CONTROLLI-ACCESS-RIGHT	CAST_COBOL_SavedSection
66239	M00	14247	CONTROLLI-ACCESS-RIGHT-EX	CAST_COBOL_SavedParagraph

Query result interpretation

All the listed objects belong to Analysis Unit " M00"

Query for SQL server

Same as CSS

Query result example

Query result interpretation

Notes/comments

Related Pages