Owner manual

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 REPLICATEPURGE