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

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

Applicable RDBMS

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