SQL Queries - CAST Knowledge Base - Queries on Transactions - How to list the ignored tables by the case insensitive regular expressions

Purpose of Query

This Query list the ignored tables by the case insensitive regular expressions.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
CSS(tick)
Query for CSS
SELECT K.idkey, 
       K.keynam, 
       K.objtyp, 
       L.det_value, 
       L.ret_value, 
       O.fullname 
FROM   keys K, 
       fp_result_objectlist L, 
       objfulnam O 
WHERE  K.idkey = L.object_id 
       AND K.idkey = O.idobj 
       AND NOT EXISTS (SELECT 1 
                       FROM   fp_result_excludedobjects E 
                       WHERE  E.object_id = L.object_id) 
Query result example
 370;"HW_COMPANY_TYPE";138017;1;0;"CQCUSER.PARTICIPATING_JEE.HW_COMPANY_TYPE"
Query result interpretation

Notes/comments



Related Pages