Purpose of Query
This page provides a query to list the number of DLM (dynamic link manager) links by object name for non reviewed links.
NOTE : If you have a large amount of DLM links, this query can then produce a large amount of results
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_fullname AS caller_name,
cdt1.object_type_str AS caller_type,
cdt2.object_fullname AS callee_name,
cdt2.object_name ,
cdt2.object_type_str AS callee_type
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
ORDER BY 2 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
"<object caller fullname>";C/C++ Function";"<object callee fullname";"<object callee name>";"C/C++ Function"
Query result interpretation
The first column is the object fullname of the caller; The second 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 third column is the object fullname of the callee; The fourth column is the object name of the callee; The fifth 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.)
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
