This document provides a query to get the list of objects the analysis of an execution unit has generated.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
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>'
"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)"
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.
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>'
"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)"
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.
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>'
"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)"
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.