SQL Queries - CAST Central Base - Queries on Objects - How to change the object status to unchanged

Created by Unknown User (sse_20162) on Feb 11, 2022
Purpose of Query

This query will force the analysis to consider the object as being unchanged.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS2(tick)
CSS1(tick)
Query for CSS
UPDATE dss_object_info 
SET    object_checksum = (SELECT object_checksum 
                          FROM   dss_object_info doi 
                          WHERE  doi.object_id = dss_object_info.object_id 
                                 AND doi.snapshot_id = <Previous Snapshot ID>) 
WHERE  snapshot_id = <Current Snapshot ID> 
       AND object_id = <Unchanged Object ID>

You should replace <Current Snapshot ID>, by the snapshot id of the current snapshot, <Previous Snapshot ID> with the snapshot id of the previous snapshot and <Unchanged Object ID> with the object id

Query result example

No result will be returned

Query result interpretation


Query for Oracle

Query for SQL server
  
Notes/comments

Query result example