Page tree
Skip to end of metadata
Go to start of metadata
Purpose of Query

 The query checks if a Data Function is part of a snapshot

Applicable CAST Version
Release
Yes/No
8.3.x  (tick)
8.2.x  (tick)
8.1.x  (tick)
8.0.x  (tick)
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server  (tick)
Microsoft SQL Server  (tick)
CSS2  (tick)
Query for CSS
SELECT EXISTS
       (
              SELECT 1
              FROM   dss_object_info dso
              JOIN   dss_objects dob
              ON     dso.object_id = dob.object_id
              JOIN   dss_snapshots dss
              ON     dso.snapshot_id = dss.snapshot_id
              WHERE  dob.object_type_id = 30002
              AND    dob.object_full_name = 'Data Function full name'
              AND    dss.snapshot_name = <'snapshot_name'> )
Query result example
 t
Query result interpretation
 The query returns 't', if the Data Function is part of the snapshot


Query for Oracle
SELECT EXISTS
       (
              SELECT 1
              FROM   dss_object_info dso
              JOIN   dss_objects dob
              ON     dso.object_id = dob.object_id
              JOIN   dss_snapshots dss
              ON     dso.snapshot_id = dss.snapshot_id
              WHERE  dob.object_type_id = 30002
              AND    dob.object_full_name = 'Data Function full name'
              AND    dss.snapshot_name = <'snapshot_name'> )
Query result example
 t
Query result interpretation
 The query returns 't', if the Data Function is part of the snapshot


Query for SQL server
SELECT EXISTS
       (
              SELECT 1
              FROM   dss_object_info dso
              JOIN   dss_objects dob
              ON     dso.object_id = dob.object_id
              JOIN   dss_snapshots dss
              ON     dso.snapshot_id = dss.snapshot_id
              WHERE  dob.object_type_id = 30002
              AND    dob.object_full_name = 'Data Function full name'
              AND    dss.snapshot_name = <'snapshot_name'> )
Query result example
 t
Query result interpretation
 The query returns 't', if the Data Function is part of the snapshot
Notes/comments
 

 

Related Pages
 
  • No labels