Hp Integrity NonStop J-Series Instrukcja Użytkownika Pobierz pdf (Strona 103)

HP NonStop SQL DDL Replicator User’s Guide—545799-007

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.

1 2 ... 98 99 100 101 102 103 104 105 106 107 108 ... 131 132

Brak uwag

Hp Integrity NonStop J-Series Instrukcja Użytkownika Strona 103