Purpose of Query
The query checks if a Data Function is part of a snapshot
Applicable 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 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
