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

Contents

HP NonStop SQL/MX Installation and Management Guide—544536-007

7. Creating an SQL/MX Database (continued)

Guidelines for Creating Constraints 7-39

Examples for Creating Constraints for SQL/MX Tables 7-39

Creating Views of SQL/MX Tables 7-39

Rules for Creating and Accessing Views 7-40

Examples for Creating Views for SQL/MX Tables 7-40

Creating Triggers 7-41

Guidelines on Using Triggers 7-41

Trigger Temporary Tables 7-41

Creating Stored Procedures in Java 7-41

Database Design Guidelines for Improving OLTP Performance 7-41

8. Querying SQL/MX Metadata

Commands for Displaying Information 8-2

DISPLAY USE OF Command 8-2

mxtool INFO Command 8-3

SHOWLABEL Command 8-3

mxtool VERIFY command 8-3

SHOWDDL Command 8-4

SQL/MX Metadata Tables 8-5

Understanding ANSI External and Internal Names 8-11

Regular Identifiers and Object Naming 8-11

Delimited Identifiers and Object Naming 8-11

Displaying System Schema Information 8-12

Locating System Schema Tables 8-12

Locating System Defaults Schema Tables 8-15

Locating MXCS Schema Tables 8-18

Displaying Catalog Information 8-20

Displaying a Catalog UID 8-20

Displaying All Catalogs Visible on a Node 8-21

Determining Whether a Catalog is Local or Remote 8-21

Displaying All Schemas in a Catalog 8-22

Displaying the Guardian Location of the Metadata Tables for a Catalog 8-22

Displaying the Attributes of a Catalog 8-23

Displaying Schema Information 8-23

Displaying a Schema UID 8-24

Displaying All Schemas Visible on a Node 8-25

Displaying All Objects in a Schema 8-26

Displaying the Attributes of a Schema 8-27