Purpose of Query
The query returns the list of object types involved in Transactions
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS
SELECT t.*,
count_
FROM (SELECT e.objtyp,
Count(1) count_
FROM (SELECT idacc,
idcle
FROM acc a
WHERE ( A.acctyphi & 7 ) != 0
AND ( A.acctyplo & 2097152 ) = 2097152
AND ( A.prop & 65536 ) = 0) a
JOIN keys e
ON e.idkey = a.idcle
GROUP BY e.objtyp) e
JOIN typ t
ON e.objtyp = t.idtyp
Query result example
1;"SQL_TABLE";"SQL Table";"ACTIVE ";1012
Query result interpretation
The query returns the id of the type, the name of the type, and the number of object involved in Transactions with this type
Query for Oracle
SELECT t.*,
count_
FROM (SELECT e.objtyp,
Count(1) count_
FROM (SELECT idacc,
idcle
FROM acc a
WHERE ( A.acctyphi & 7 ) != 0
AND ( A.acctyplo & 2097152 ) = 2097152
AND ( A.prop & 65536 ) = 0) a
JOIN keys e
ON e.idkey = a.idcle
GROUP BY e.objtyp) e
JOIN typ t
ON e.objtyp = t.idtyp
Query result example
1;"SQL_TABLE";"SQL Table";"ACTIVE ";1012
Query result interpretation
The query returns the id of the type, the name of the type, and the number of objects involved in Transactions with this type
Query for SQL server
SELECT t.*,
count_
FROM (SELECT e.objtyp,
Count(1) count_
FROM (SELECT idacc,
idcle
FROM acc a
WHERE ( A.acctyphi & 7 ) != 0
AND ( A.acctyplo & 2097152 ) = 2097152
AND ( A.prop & 65536 ) = 0) a
JOIN keys e
ON e.idkey = a.idcle
GROUP BY e.objtyp) e
JOIN typ t
ON e.objtyp = t.idtyp
Query result example
1;"SQL_TABLE";"SQL Table";"ACTIVE ";1012
Query result interpretation
The query returns the id of the type, the name of the type, and the number of objects involved in Transactions with this type
Notes/comments
Related Pages
