SQL/MX 2.x Installation and Management Guide (H06.04+)

Contents

HP NonStop SQL/MX Installation and Management Guide—540436-001

7. Creating an SQL/MX Database (continued)

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-14

Regular Identifiers and Object Naming 8-14

Delimited Identifiers and Object Naming 8-14

Displaying System Schema Information 8-15

Locating System Schema Tables 8-15

Locating System Defaults Schema Tables 8-18

Locating MXCS Schema Tables 8-21

Displaying Catalog Information 8-23

Displaying a Catalog UID 8-23

Displaying All Catalogs Visible on a Node 8-24

Determining Whether a Catalog is Local or Remote 8-24

Displaying All Schemas in a Catalog 8-25

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

Displaying the Attributes of a Catalog 8-26

Displaying Schema Information 8-26

Displaying a Schema UID 8-27

Displaying All Schemas Visible on a Node 8-28

Displaying All Objects in a Schema 8-29

Displaying the Attributes of a Schema 8-30

Displaying the Owner of a Schema 8-30

Displaying Table Information 8-31