SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Contents
HP NonStop SQL/MX Reference Manual—640322-001
xvii
5. SQL/MX Utilities (continued)
5. SQL/MX Utilities (continued)
Examples of VERIFY 5-126
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-25
Interval Data Types 6-31
Numeric Data Types 6-34
DEFINEs 6-38
Using DEFINEs 6-38