Purpose of Query
To find out the types of objects counted in CMS (View analysis unit content).
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
Observed on RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS | |
Query for CSS
SELECT t.*
FROM Typ t ,
TypCat tc,
Cat c
WHERE t.IdTyp = tc.IdTyp
AND tc.IdCatParent = c.IdCat
AND c.IdCat = 6100
Query result example
Query gives the following result:
idtyp integer | typname character varying (255) | typ dsc character varying (255) | statuts character (10) | |
|---|---|---|---|---|
| 1 | 1 | SQL Table | SQL Table | ACTIVE |
| 2 | 141260 | CAST_TSQL_UDT_TABLE | SQL Server UDT TABLE | ACTIVE |
| 3 | 141449 | CAST_ABAP_SAPUnresolvedTable | SAP unresolved Table | ACTIVE |
| 4 | 133031 | SAPTable | SAP Table | ACTIVE |
| 5 | 138017 | CAST_Oracle_RelationalTable | Oracle table | ACTIVE |
| 6 | 140697 | CAST_Oracle_ObjectTable | Oracle object table | ACTIVE |
| 7 | 138791 | CAST_Oracle_MaterializedView | Oracle materialized view | ACTIVE |
| 8 | 141046 | CAST_DB2ZOS_RelationalTable | DB2 z/OS relational table | DEPRECATED |
| 9 | 140978 | CAST_ASETSQL_RelationalTable | Sybase table | ACTIVE |
| 10 | 138871 | CAST_MSTSQL_RelationalTable | Microsoft table | ACTIVE |
Query result interpretation
The result displays all the type of objects counted in CMS. This types are based on category 6100 DataBase Table and computed by the stored procedure APM_SCOPE_TABLES.
Query for Oracle
Same as CSS
Query result example
Query result interpretation
Query for SQL server
Same as CSS
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
