SQL Queries - CAST Knowledge Base - Queries on Links - How to count the number of links having a table as callee

Purpose of Query

The query retrieves the number of links having a table as callee.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
CSS(tick)
Query for CSS
SELECT Count (*) 
FROM   acc a, 
       (SELECT idkey 
        FROM   keys 
        WHERE  objtyp IN ( 139003, 1, 3, 4, 
                           6, 9, 10, 12, 
                           15, 17, 18, 529, 
                           954, 106000, 22, 278, 
                           301, 302, 303, 304, 
                           358, 107000 )) ServerObjects 
WHERE  a.idcle = ServerObjects.idkey 
Query result example
 0
Query result interpretation
 The number of links having a table as callee is 0
Notes/comments



Related Pages