SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Contents
HP NonStop SQL/MX Reference Manual—544517-008
xvi
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
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-20
Datetime Data Types 6-24
Interval Data Types 6-29
Numeric Data Types 6-32
DEFINEs 6-35
Using DEFINEs 6-35
Using DEFINEs From MXCI 6-37
DEFINEs of Class MAP 6-37
Expressions 6-38
Character Value Expressions 6-38
Datetime Value Expressions 6-40
Interval Value Expressions 6-44