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;"
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
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"
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