HP NonStop G-Series User Manual
Page 102
SQL DDL Statements
HP NonStop SQL DDL Replicator User’s Guide —545799-005
A-2
DDL Statements
CREATE INDEX
If the CREATE INDEX statement contains the option PARALLEL
EXECUTION ON CONFIG config-file, note that:
•
SDR does not move the config-file to the backup system so it
must be moved to the backup by other means
•
SDR translates the primary config-file name to the backup
config-file name
•
The content of the config-file must specify volume and file
names on the backup system
CREATE TABLE
CREATE TABLE LIKE references an existing table for column
definitions. This table must be present on the backup system, with
the name that RDF would use if it were replicating that table.
If the table is partitioned, all partitions must be replicated by RDF.
CREATE VIEW
A shorthand view is a SQL object that is neither audited nor
unaudited. When a shorthand view is created on the primary system,
SDR assumes it is audited and captures it just as it would an audited
table creation.
On the backup system, the SDR updater examines the tables
referenced in the CREATE VIEW statement. If any of those tables
are audited, SDR replicates the CREATE VIEW; otherwise, it
considers the view to be unaudited and does not replicate it unless
the UNAUDITEDDDL global parameter is set to ON.
DROP CATALOG
DROP processing depends on how RDF REPLICATEPURGE is set.
See
DROP
CONSTRAINT
DROP processing depends on how RDF REPLICATEPURGE is set.
See
DROP INDEX
DROP processing depends on how RDF REPLICATEPURGE is set.
See
DROP TABLE
DROP processing depends on how RDF REPLICATEPURGE is set.
See
DROP VIEW
DROP processing depends on how RDF REPLICATEPURGE is set.
See
DUP
DUP is an SQLCI utility, not a standard DDL operation. It is not
replicated by SDR.
DDL Operation
Considerations and Processing Notes