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