SQL Queries - CAST Knowledge Base - Queries on Links - How to get the List of DLM links by type

Purpose of Query

This page provides a query to list the number of unreviewed DLM (dynamic link manager) links by type

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   cdt1.object_type_str,
         cdt2.object_type_str,
         COUNT (1)
FROM     cdt_objects cdt1,
         cdt_objects cdt2,
         acc a
WHERE    a.prop  = 1
AND      a.idclr = cdt1.object_id
AND      a.idcle = cdt2.object_id
GROUP BY cdt1.object_type_str,
         cdt2.object_type_str
ORDER BY 3 DESC

This query is for non-reviewed links. This can be modified for other types of links by changing the where clause of a.prop to the appropriate value. Please see the following page for more information: SQL Queries - CAST Knowledge Base - Queries on Links - How to determine DLM status

Query result example

"C/C++ Function";"C/C++ Function";18008

Query result interpretation

The first column is the detailed technology type of the caller technology such as oracle, C; Java, etc. and further definition of the type such as method, function, table, etc.) ; The second column is the detailed technology type of the callee technology such as oracle, C; Java, etc. and further definition of the type such as method, function, table, etc.) ; The third column is the number of DLM links between these two types

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages