HP 3000 Manuals HP 3000 Manuals
Chapter 6 ALLBASE/Replicate Statement Syntax Reference
This chapter describes all the SQL statements associated with
ALLBASE/Replicate in alphabetical order, giving syntax, parameters,
descriptions, authorization requirements, and examples for each
statement. Examples often consist of groups of statements so you can see
how each statement is related to other statements functionally.
The new and modified ALLBASE/Replicate statements are summarized in Table
6-1 .
Table 6-1. ALLBASE/Replicate Statement Summary
---------------------------------------------------------------------------------------------------
| | | | |
| Group | Category | Statement | Replicate Use |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| Modified statements | Creating | START DBE NEW | New parameters for defining |
| | DBEnvironments | | and controlling audit logging |
| | | | for a DBEnvironment. |
| | | | |
| | Creating logs | START DBE NEWLOG | New parameters for defining |
| | | | and controlling audit logging |
| | | | for a DBEnvironment. |
| | | | |
| | Creating tables | CREATE TABLE | New parameter for assigning |
| | | | partitions. |
| | | | |
| | Altering tables | ALTER TABLE | New parameter for altering |
| | | | partition assignments. |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| New statements | Audit logging | LOG COMMENT | Creates a comment audit log |
| | statements | | record that can later be |
| | | | analyzed with the Audit Tool. |
| | | | |
| | | DISABLE AUDIT | Disables audit logging for a |
| | | LOGGING | session. |
| | | | |
| | | ENABLE AUDIT | Reenables audit logging for a |
| | | LOGGING | session. |
| | | | |
| | Partition | CREATE PARTITION | Defines partitions. |
| | management | | |
| | statements | | |
| | | | |
| | | DROP PARTITION | Removes partition |
| | | | definitions. |
| | | | |
---------------------------------------------------------------------------------------------------