NonStop SQL DDL Replicator User's Guide (Update 6)

HP NonStop SQL DDL Replicator User’s Guide—545799-006
A-1
A SQL DDL Statements
This appendix describes the SQL DDL statements that are replicated and, in some
cases, specific information about how SDR translates them. The HP RESTORE utility,
references to catalogs, physical volumes, and WITH SHARED ACCESS are also
discussed.
DDL Statements
The RESTORE Utility
Catalog References in Statements
PHYSVOL References in Statements
WITH SHARED ACCESS Clauses
DDL Statements
Table A-1 lists the DDL statements processed by SDR with notes on special
processing, where applicable.
Table A-1.
DDL Operation Considerations and Processing Notes
ALTER CATALOG
ALTER COLLATION
ALTER INDEX
ALTER TABLE ALTER TABLE NO AUDIT is replicated.
ALTER TABLE AUDIT is not replicated unless unaudited replication
is selected by setting the global parameter UNAUDITEDDDL to ON.
ALTER VIEW
COMMENT
CREATE CATALOG
See discussion in paragraph Create Catalog on page 4-5.
CREATE
COLLATION
This statement references an Enscribe edit file. Like all other
secondary references, RDF must be configured to replicate the
backup edit file name. The backup edit file should be created before
executing the CREATE COLLATION statement.
CREATE
CONSTRAINT
CREATE SYSTEM
CATALOG
Is not replicated. It must be performed as a local operation when
SQL is first installed.