SQL Queries - CAST Knowledge Base - Queries on objects - How to check if the object have a unknown type

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

This page contains a query to be run on Knowledge Database which will help us to find if the object parent is unknown.

Applicable CAST Version

 

Release
Yes/No
8.3.x(tick)
Applicable RDBMS

 

RDBMS
Yes/No
CSS(tick)



Query for CSS
SELECT * 
FROM   keys k 
       JOIN typ t 
         ON t.idtyp = k.objtyp 
where idkey = <object_id>
ORDER  BY idkey ASC
Query result example
 

5102469;'00/00/0000';'';'XXXXXX';-1;22210;32;140667;'???';'1970-01-01 00:00:00';'';0;'';140667;'CAST_CICS_TDQueuePrototype';'Unknown CICS Transient Data';'ACTIVE '

If typdsc column contain 'Unknown', then the parent is unknown.

Query result interpretation
 The query has returned the object linked to an unknown parent.
Notes/comments
 Ticket # 6803



Related Pages