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

Contents
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
xviii
6. SQL/MX Language Elements
Example of UPGRADE 5-138
VERIFY Operation 5-140
Considerations for VERIFY 5-141
Examples of VERIFY 5-143
6. SQL/MX Language Elements
Catalogs 6-3
SQL/MX Catalogs 6-3
SQL/MP Catalogs 6-3
Character Sets 6-4
Restrictions on Using Character Set Data 6-4
Collations 6-6
Columns 6-7
Column References 6-7
Derived Column Names 6-7
Column Default Settings 6-8
Examples of Derived Column Names 6-8
Constraints 6-9
Creating, Adding, and Dropping Constraints on SQL/MX Tables 6-9
Creating and Dropping Constraints on SQL/MP Tables 6-10
Correlation Names 6-11
Explicit Correlation Names 6-11
Implicit Correlation Names 6-11
Examples of Correlation Names 6-11
Database Objects 6-12
Ownership
6-12
Database Object Names
6-13
Logical Names for SQL/MX Objects
6-13
Physical Names for SQL/MP Objects 6-13
Logical Names for SQL/MP Objects 6-14
DEFINE Names for SQL/MP Objects
6-14
SQL/MX Object Namespaces
6-15
Considerations for Database Object Names 6-15
Data Types
6-17
Comparable and Compatible Data Types
6-17
Character String Data Types
6-22
Datetime Data Types
6-26
Interval Data Types 6-31
Numeric Data Types
6-34