SQL Queries - CAST Knowledge Base - Queries on jobs - How to get the list of objects resulting from the analysis of an execution unit

Created by Salim Frontin on Feb 11, 2022
Purpose of Query

This document provides a query to get the list of objects the analysis of an execution unit has generated.

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 k.KeyNam    ,
       ofn.FullName ,
       ot.ObjTypStr
FROM   ObjTypStr ot
       JOIN Keys k
       ON     k.ObjTyp=ot.ObjTyp
       JOIN objpro op
       ON     op.idObj=k.idKey
       JOIN AnaPro ap
       ON     ap.idPro = op.idPro
       JOIN AnaJob aj
       ON     aj.idJob = ap.idJob
       JOIN ObjFulNam ofn
       ON     ofn.idObj = k.idKey
WHERE  aj.JobNam        ='<EXECUTION_UNIT_NAME>' -- you must type the name in the same case as displayed in the CAST-MS Task Window : 'Run <Technology> Analyzer for <Execution Unit Name>'
Query result example

"OWNER_CODE";"LARA_INT.SCE.COMMON.OWNER_CODE";"Oracle table column"
"OWNER_CODE";"BPLS0001.COMMON.OWNER_CODE";"Oracle Forms DataBlock Item"
"BTN_EXTRACT_PML";"PFS1226.LOCAL.BTN_EXTRACT_PML";"Oracle Forms DataBlock Item"
"COMMON_ID";"BPLS0001.COMMON_ID";"Oracle Forms Menu Module Parameter"
"ISO_CODE";"LARA_INT.SCE.EDI_BP_CARGO.ISO_CODE";"Oracle table column"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.509.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.509.txt";"source file (subject to parsing)"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.897.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.897.txt";"source file (subject to parsing)"
"DELETE_FLAG";"LARA_INT.SCE.SCREEN_RULE.DELETE_FLAG";"Oracle table column"
"WHEN-BUTTON-PRESSED";"EDS0090.BTN.BTN_PARTNER_GROUPING.WHEN-BUTTON-PRESSED";"Oracle Forms Trigger"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.1707.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.1707.txt";"source file (subject to parsing)"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_Trigger.2067.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_Trigger.2067.txt";"source file (subject to parsing)"

Query result interpretation

All these objects were created during the analysis of this execution unit.

It can be useful to know if two objects were analyzed in the same execution unit, in case of missing links for example.

Query for Oracle
SELECT k.KeyNam    ,
       ofn.FullName ,
       ot.ObjTypStr
FROM   ObjTypStr ot
       JOIN Keys k
       ON     k.ObjTyp=ot.ObjTyp
       JOIN objpro op
       ON     op.idObj=k.idKey
       JOIN AnaPro ap
       ON     ap.idPro = op.idPro
       JOIN AnaJob aj
       ON     aj.idJob = ap.idJob
       JOIN ObjFulNam ofn
       ON     ofn.idObj = k.idKey
WHERE  aj.JobNam        ='<EXECUTION_UNIT_NAME>' -- you must type the name in the same case as displayed in the CAST-MS Task Window : 'Run <Technology> Analyzer for <Execution Unit Name>'
Query result example

"OWNER_CODE";"LARA_INT.SCE.COMMON.OWNER_CODE";"Oracle table column"
"OWNER_CODE";"BPLS0001.COMMON.OWNER_CODE";"Oracle Forms DataBlock Item"
"BTN_EXTRACT_PML";"PFS1226.LOCAL.BTN_EXTRACT_PML";"Oracle Forms DataBlock Item"
"COMMON_ID";"BPLS0001.COMMON_ID";"Oracle Forms Menu Module Parameter"
"ISO_CODE";"LARA_INT.SCE.EDI_BP_CARGO.ISO_CODE";"Oracle table column"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.509.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.509.txt";"source file (subject to parsing)"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.897.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.897.txt";"source file (subject to parsing)"
"DELETE_FLAG";"LARA_INT.SCE.SCREEN_RULE.DELETE_FLAG";"Oracle table column"
"WHEN-BUTTON-PRESSED";"EDS0090.BTN.BTN_PARTNER_GROUPING.WHEN-BUTTON-PRESSED";"Oracle Forms Trigger"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.1707.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.1707.txt";"source file (subject to parsing)"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_Trigger.2067.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_Trigger.2067.txt";"source file (subject to parsing)"

Query result interpretation

All these objects were created during the analysis of this execution unit.

It can be useful to know if two objects were analyzed in the same execution unit, in case of missing links for example.

Query for SQL server
SELECT k.KeyNam    ,
       ofn.FullName ,
       ot.ObjTypStr
FROM   ObjTypStr ot
       JOIN Keys k
       ON     k.ObjTyp=ot.ObjTyp
       JOIN objpro op
       ON     op.idObj=k.idKey
       JOIN AnaPro ap
       ON     ap.idPro = op.idPro
       JOIN AnaJob aj
       ON     aj.idJob = ap.idJob
       JOIN ObjFulNam ofn
       ON     ofn.idObj = k.idKey
WHERE  aj.JobNam        ='<EXECUTION_UNIT_NAME>' -- you must type the name in the same case as displayed in the CAST-MS Task Window : 'Run <Technology> Analyzer for <Execution Unit Name>'
Query result example

"OWNER_CODE";"LARA_INT.SCE.COMMON.OWNER_CODE";"Oracle table column"
"OWNER_CODE";"BPLS0001.COMMON.OWNER_CODE";"Oracle Forms DataBlock Item"
"BTN_EXTRACT_PML";"PFS1226.LOCAL.BTN_EXTRACT_PML";"Oracle Forms DataBlock Item"
"COMMON_ID";"BPLS0001.COMMON_ID";"Oracle Forms Menu Module Parameter"
"ISO_CODE";"LARA_INT.SCE.EDI_BP_CARGO.ISO_CODE";"Oracle table column"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.509.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.509.txt";"source file (subject to parsing)"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.897.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.897.txt";"source file (subject to parsing)"
"DELETE_FLAG";"LARA_INT.SCE.SCREEN_RULE.DELETE_FLAG";"Oracle table column"
"WHEN-BUTTON-PRESSED";"EDS0090.BTN.BTN_PARTNER_GROUPING.WHEN-BUTTON-PRESSED";"Oracle Forms Trigger"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.1707.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_DataBlockItem.1707.txt";"source file (subject to parsing)"
"Z:\Deploy\LARA_INT_TEST\CAST_Forms_Trigger.2067.txt";"Z:\Deploy\LARA_INT_TEST\CAST_Forms_Trigger.2067.txt";"source file (subject to parsing)"

Query result interpretation

All these objects were created during the analysis of this execution unit.

It can be useful to know if two objects were analyzed in the same execution unit, in case of missing links for example.

Notes/comments

Related Pages