SQL Queries - CAST Knowledge Base - Queries on Links - How to determine DLM status

Purpose

This page provides information on how to determine DLM (Dynamic Link Manager) status based on tables in the local database (KB).

For more information, refer to:

For 8.3: Official documentation: Dynamic Link Manager
For 8.2: Official documentation: Dynamic Link Manager
For 8.1: Official documentation: Dynamic Link Manager
For 8.0: Official documentation: Dynamic Link Manager

Applicable in 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	✅

Details

Run the following query on the KB to determine the information on the links stored in the KB.

SELECT
         CASE
                  WHEN prop=0
                  THEN 'default link non-DLM'
                  WHEN prop=1
                  THEN 'DLM link to be reviewed'
                  WHEN prop=32769
                  THEN 'DLM link reviewed validated'
                  WHEN prop=65537
                  THEN 'DLM link reviewed ignored'
         END,
         COUNT(prop)
FROM     acc
GROUP BY prop
ORDER BY prop;

A value of 0 for the prop column of the acc table indicates that these links are the default links from the analyzer (not Dynamic links).
A value of 1 for the prop column of the acc table indicates that these links are Dynamic links which need to be reviewed.
A value of 32769 for the prop column of the acc table indicates that these links are Dynamic links which have been reviewed and are validated.
A value of 65537 for the prop column of the acc table indicates that these links are Dynamic links which have been reviewed and are being ignored.

The query above will list the number of links found for each of these values of the column as shown below.

Query result example

“default link non-DLM”;100

“DLM link to be reviewed”;10

“DLM link reviewed validated”;9

“DLM link reviewed ignored”;7

Notes/comments

Related Pages