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

Created by Amine Benarbia on Feb 11, 2022
Purpose of Query

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

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS(tick)
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