SQL Queries - CAST Central Base - Queries on objects - How to get the Checksum value of an object

Purpose

This page provides you with the definition of the checksum value of an object, and how to get this value from the central base.

Checksum values are calculated by CAST AIP for objects resulting from an analysis and are used to determine whether an object has changed between successive snapshots, however, CAST AIP is not able to determine the checksum for certain objects and these objects always have a checksum value of 0.

Applicable in CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS2

Query for CSS

SELECT doi.object_checksum, 
       doi.snapshot_id 
FROM   dss_object_info doi 
       JOIN dss_objects dso 
         ON doi.object_id = dso.object_id 
WHERE  dso.object_full_name = 'Full_name'

Query result example

1933263931;1
1933263931;2

Query result interpretation

This means that the checksum value of the object 'Full_name' is equal to 1933263931 in snapshot 1 and snapshot 2

Query for Oracle

SELECT doi.object_checksum, 
       doi.snapshot_id 
FROM   dss_object_info doi 
       JOIN dss_objects dso 
         ON doi.object_id = dso.object_id 
WHERE  dso.object_full_name = 'Full_name'

Query result example

1933263931;1
1933263931;2

Query result interpretation

This means that the checksum value of the object 'Full_name' is equal to 1933263931 in snapshot 1 and snapshot 2

Query for SQL Server

SELECT doi.object_checksum, 
       doi.snapshot_id 
FROM   dss_object_info doi 
       JOIN dss_objects dso 
         ON doi.object_id = dso.object_id 
WHERE  dso.object_full_name = 'Full_name'

Query result example

1933263931;1
1933263931;2

Query result interpretation

This means that the checksum value of the object 'Full_name' is equal to 1933263931 in snapshot 1 and snapshot 2

Notes/comments

Related Pages