The queries on this page provide information on the Module content summary and detail similar to the Module Content seen in CAST-MS (associated documentation for this is here: CMS - User Defined Module editor). One query provides the number of objects per type, per subset and per module in a local base, which can be done based on an individual module. The details of the objects in a module is also shown in another query.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
This query provides the number of objects and details for all modules:
SELECT k0.KeyNam AS "Module Name", k.KeyNam AS "Subset Name", t.TypNam AS "Type Name" , COUNT(coa.OBJECT_TYPE) AS "Objects Number" FROM SETROOT sr JOIN Keys k0 ON k0.IdKey = sr.IDSET JOIN CTT_OBJECT_APPLICATIONS coa ON coa.APPLICATION_ID = sr.IDROOT JOIN Keys k ON k.IdKey = sr.IDROOT JOIN Typ t ON t.IdTyp = coa.OBJECT_TYPE GROUP BY k0.KeyNam, k.KeyNam , t.TypNam ORDER BY k0.KeyNam, k.KeyNam , t.TypNam
"ora_test full content";"ora_test full content_CAST_Oracle_Subset";"CAST_Oracle_Schema";5
"ora_test full content";"ora_test full content_CAST_Oracle_Subset";"CAST_Oracle_Sequence";3
"ora_test full content";"ora_test full content_CAST_Oracle_Subset";"CAST_Oracle_TableColumn";619
"ora_test full content";"ora_test full content_CAST_Oracle_Subset";"CAST_Oracle_Subset";1
The query provides the module name, the subset name, the type, and the count of each objects for that type in that module.
If you want to qualify it for a specific module then you can add the line:
Where k0.keynam = '<your Module Name>'
before the GROUP BY line
.You can get the module name for a specific object by using this query: SQL Queries - CAST Knowledge Base - Queries on Module - Module content and properties
This query provides the details on the objects for a specific module (the name of the specific module needs to be provided - also please be aware that this query may return a large set of data for a module with a large number of objects). You can get the module name for a specific object by using this query: SQL Queries - CAST Knowledge Base - Queries on Module - Module content and properties
SELECT k0.KeyNam AS "Module Name" , K1.KeyNam AS "Object Name" , o.fullname AS "Full Name" , rp.path AS "Object Full Path", t.typnam AS "Type" FROM SETROOT sr JOIN Keys k0 ON k0.IdKey = sr.IDSET JOIN CTT_OBJECT_APPLICATIONS coa ON coa.APPLICATION_ID = sr.IDROOT JOIN Keys k ON k.IdKey = sr.IDROOT JOIN Typ t ON t.IdTyp = coa.OBJECT_TYPE JOIN keys k1 ON k1.idkey = coa.object_id JOIN OBJFULNAM o ON o.idobj = k1.idkey JOIN objfilref ofr ON k1.idkey = ofr.idobj JOIN refpath rp ON ofr.idfilref =rp.idfilref WHERE k0.keyNam = '<your Module Name>'
"mongo full content";"String";"java.lang.String";"C:\ProgramData\CAST\CAST\CASTMS\LISA\15aa4bd48ead47fb97244bde0395c324\Scr6e3556c049054d72a7dc2629512b4095\JavaExtractedFiles\Classes\java\lang\String_8d8a37479ba8b8a0.java";"JV_CLASS"
The query provides the details on the objects in the module including the object name, type, and path