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

SQL/MX Subvolume and File Naming Guidelines.......................................................................73
SQL/MX Subvolume Naming Guidelines..............................................................................74
SQL/MX Data File Naming Guidelines.................................................................................74
Resource Forks...................................................................................................................74
Designating Wild Cards in SQL/MX Schema Names.............................................................75
Using the LOCATION Clause...............................................................................................75
Using the Subvolume Option in the CREATE SCHEMA Statement..............................................75
Correcting File Name Problems............................................................................................76
Creating SQL/MX Metadata....................................................................................................76
Creating Catalogs..................................................................................................................77
Catalog Naming...............................................................................................................77
Rules for Creating and Dropping Catalogs............................................................................77
Examples for Creating a Catalog.........................................................................................78
Creating Catalogs for Single-Node and Distributed Systems....................................................78
Reserved Catalogs.............................................................................................................78
Creating Schemas..................................................................................................................78
Schema Naming...............................................................................................................78
Rules for Creating and Dropping Schemas............................................................................78
Examples for Creating Schemas...........................................................................................78
Access Privileges for SQL/MX Database Objects........................................................................79
Granting and Revoking Access Privileges to SQL/MX Database Objects...................................79
Examples for Granting Privileges..........................................................................................80
Revoking Access Privileges..................................................................................................80
Access Privileges for SQL/MX Utilities...................................................................................80
Creating SQL/MX Tables.........................................................................................................80
Security Rules for Creating and Altering SQL/MX Tables.........................................................80
Creating and Using Keys....................................................................................................81
Creating and Managing Partitions for SQL/MX Tables............................................................83
Additional Guidelines for Creating Tables.............................................................................87
Managing Table Data........................................................................................................88
Creating Indexes for SQL/MX Tables........................................................................................96
Rules for Creating and Accessing Indexes.............................................................................96
Creating an Index..............................................................................................................97
Creating and Managing Partitions for SQL/MX Indexes..........................................................98
Creating Constraints on SQL/MX Tables....................................................................................99
Rules for Adding and Dropping Constraints...........................................................................99
Creating, Adding, and Dropping Constraints.........................................................................99
Naming Constraints.........................................................................................................100
Constraints Implemented With Indexes................................................................................100
Guidelines for Creating Constraints....................................................................................100
Examples for Creating Constraints for SQL/MX Tables..........................................................101
Creating Views of SQL/MX Tables..........................................................................................101
Rules for Creating and Accessing Views..............................................................................101
Examples for Creating Views for SQL/MX Tables.................................................................101
Creating Sequence Generators...............................................................................................102
Creating Triggers..................................................................................................................102
Guidelines on Using Triggers.............................................................................................102
Trigger Temporary Tables..................................................................................................102
Creating Stored Procedures in Java.........................................................................................102
Database Design Guidelines for Improving OLTP Performance....................................................103
Accessing an SQL/MP Database From NonStop SQL/MX.........................................................104
6 Querying SQL/MX Metadata..................................................................105
Commands for Displaying Information.....................................................................................106
DISPLAY USE OF Command..............................................................................................106
Contents 5