User guide

SQL DDL Statements
HP NonStop SQL DDL Replicator User’s Guide—545799-007
A-3
The RESTORE Utility
The RESTORE Utility
When restoring SQL tables and indexes, the RESTORE utility performs many DDL
operations such as DROP, CREATE, and ALTER. Because the data being restored is
not replicated by RDF, the DDL operations performed by RESTORE are not captured
or replicated by SDR.
The same applies to the UNPAK utility, because it invokes RESTORE.
SQL object in Statement
The target SQL object is the first SQL object name in the statement. In general (except
for a CREATE), if the target SQL object does not exist, the SQL error is ignored and
SDR proceeds to restart the RDF updaters. CREATE, of course, will not get a SQL
error if the target SQL object does not exist.
If there is a secondary reference (such as partition, catalog, LIKE table, etc.) to a SQL
object that does not exist, the resulting SQL error causes SDR to issue an EMS
message and wait for operator intervention.
Catalog References in Statements
Catalog names, including default catalog names, must be translated to the backup file
names using the RDF configuration. If you have an RDF mapfile and wish to map
catalog names, then the filename $vol.subvol.CATALOG must be appropriately
mapped.
PURGE PURGE is an SQLCI utility that is converted to a DROP statement
for each SQL object that is referenced by the file set. The individual
DROP statements are replicated separately by SDR, depending on
the REPLICATEPURGE setting. See REPLICATEPURGE
discussion
in Section 3, Configuring SDR
.
References to programs and Enscribe files are not processed by
SDR
SECURE SECURE is an SQLCI utility that is converted by SQLCI to an
ALTER statement for each SQL object that is referenced by the file
set. The individual ALTER statements are replicated separately by
SDR.
References to programs and Enscribe files are not processed by
SDR.
UPDATE
STATISTICS
By default, the capture of UPDATE STATISTICS is suppressed.
It can be enabled by setting the global parameter
UPDATESTATISTICS to ON. See the description of ALTER GLOBAL
on page 6-5.
DDL Operation Considerations and Processing Notes