SQL Queries - CAST Knowledge Base - Queries on Links - How to count the number of links generated by the linker CPP or Mainframe

Purpose of Query

The query retrieve the number of links generated by the linker CPP or Mainframe on the Knowledge base.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS✅

Query for CSS

SELECT Count(*) 
FROM   acc 
WHERE  idpro IN (SELECT idkey 
                 FROM   keys 
                 WHERE  objtyp = 140370)

Query result example

–139

Query result interpretation

The query return the count of the number of links generated by the linker CPP or Mainframe

Query for Oracle

Query result example

Query result interpretation

Query for SQL server

Query result example

Query result interpretation

Notes/comments

Related Pages