Purpose of Query
The query will result in changing the label of the snapshot
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS
UPDATE <central>.dss_snapshots SET snapshot_name = '<new_label>' WHERE snapshot_id = <snapshot_id>; <central> - name of the central where snapshot is generated <new_label> - desired label <snapshot_id> - snapshot id of a particular snapshot can be obtained from dss_snapshots table
Query result example
Query result interpretation
The above query has changed the snapshot_name to Test_snapshots
Query for Oracle
Same as CSS2
Query result example
Query result interpretation
Query for SQL server
Same as CSS2
Query result example
Query result interpretation
Notes/comments
Related Pages
