SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
vii
2. SQL/MX Statements
Late Bind 2-105
Embedding the Statement in an SQL Program 2-105
Partitioned Tables 2-105
Authorization and Availability Requirements 2-105
Examples of CREATE SQLMP ALIAS 2-105
CREATE TABLE Statement 2-106
Syntax Description of CREATE TABLE 2-110
Considerations for CREATE TABLE 2-123
Reserved Table Names 2-123
Partitions 2-123
The LIKE specification 2-123
Audited and Nonaudited Tables 2-125
Authorization and Availability Requirements 2-125
Reduced Space Requirements for NOT DROPPABLE Constraints 2-125
Constraints Implemented With Indexes 2-125
Limits for Tables 2-126
Creating Partitions Automatically 2-126
IDENTITY Column and internal Sequence Generators 2-128
SG Table 2-129
Considerations for an IDENTITY column 2-129
Restrictions for an IDENTITY Column 2-130
Generating Values for an IDENTITY Column 2-131
Sequence Generator Cache 2-133
Gaps in IDENTITY column values 2-135
Gaps in sequence generator values 2-135
SQL/MX Extensions to CREATE TABLE 2-135
Considerations for Referential Integrity
2-136
Circular Dependency 2-136
Conflicting and Duplicate Constraints 2-136
Utilities
2-136
Usage and Performance
2-137
Examples of CREATE TABLE 2-137
IDENTITY column examples
2-140
CREATE TRIGGER Statement
2-143
Syntax Description of CREATE TRIGGER
2-144
Considerations for CREATE TRIGGER
2-146
Triggers and Utilities 2-146
Authorization and Availability Requirements
2-147
Trigger Types 2-147