SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Installation and Management Guide—523723-004
v
7. Creating an SQL/MX Database
7. Creating an SQL/MX Database
Accessing an SQL/MP Database From NonStop SQL/MX 7-1
Preparing to Create Your SQL/MX Database 7-2
SQL/MX Subvolume and File Naming Guidelines 7-2
SQL/MX Subvolume Naming Guidelines 7-2
SQL/MX Data File Naming Guidelines 7-3
Resource Forks 7-3
Designating Wild Cards in SQL/MX Schema Names 7-4
Using the LOCATION Clause 7-4
Using the Subvolume Option in the CREATE SCHEMA Statement 7-4
Correcting File Name Problems 7-5
Creating SQL/MX Metadata 7-6
Creating Catalogs 7-6
Catalog Naming 7-7
Rules for Creating and Dropping Catalogs 7-7
Examples for Creating a Catalog 7-7
Creating Catalogs for Single-Node and Distributed Systems 7-7
Reserved Catalogs 7-8
Creating Schemas 7-8
Schema Naming 7-8
Rules for Creating and Dropping Schemas 7-8
Examples for Creating Schemas 7-8
Access Privileges for SQL/MX Database Objects 7-9
Granting and Revoking Access Privileges to SQL/MX Database Objects 7-10
Examples for Granting Privileges 7-10
Revoking Access Privileges 7-10
Access Privileges for SQL/MX Utilities 7-10
Creating SQL/MX Tables 7-11
Security Rules for Creating and Altering SQL/MX Tables 7-11
Creating and Using Keys 7-11
Creating Table Partitions 7-15
Additional Guidelines for Creating Tables 7-19
Managing Table Data 7-20
Creating Indexes for SQL/MX Tables 7-31
Rules for Creating and Accessing Indexes 7-31
Creating an Index 7-32
Partitioning Indexes 7-33
Creating Constraints on SQL/MX Tables 7-35
Rules for Adding and Dropping Constraints 7-35