SQL Queries - CAST Central Base - Queries on modules - How to get the User defined snapshot version of modules

Purpose of Query

This page provide the user defined snapshot version of module(s ).

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS

Query for CSS

SELECT si.object_id, 
       o.object_name, 
       si.object_version 
FROM   dss_snapshot_info si, 
       dss_objects o 
WHERE  si.snapshot_id = 1 
       AND si.object_id = o.object_id 
       AND o.object_type_id = 20000

Query result example

4;"application_new full content";"My Version"

Query result interpretation

In this example we have one user defined snapshot module, the version name is "My Version"

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages