SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

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