Purpose of Query
This query when run on the CAST management base will make sure that the analysis units are tagged to their respective modules
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
CSS4 | |
CSS3 |
Query for JAVA (CSS, Oracle, SQL Server)
How to check for overlapping analysis units (here it is JAVA case)
insert into CMS_ObjectLinks (Caller_Id, Callee_Id, Symbol, Position) select cpof.Object_Id, min(mau.Object_Id), 'analysisunits', 0 from CMS_PORTF_Module cpm join CMS_PORTF_ObjectFilter cpof on cpof.Module_Id = cpm.Object_Id join MAINT_AnalysisUnits mau on mau.Object_Name = cpm.Object_Name and mau.Active = 1 where not exists (select 1 from CMS_ObjectLinks col where col.Caller_Id = cpof.Object_Id and col.Symbol = 'analysisunits' ) group by cpof.Object_Id;
Query result example
Query result interpretation
Any analysis unit not tagged to the corresponding module based on AU will be referenced correctly with the AU.
Notes/comments
Ticket # 33484