SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxix
6. SQL/MX Language Elements
SQL/MX Object Namespaces 6-15
Considerations for Database Object Names 6-15
OBJECTS Table 6-15
Mixing Name Types 6-16
Default Name Types 6-16
Data Types 6-17
Comparable and Compatible Data Types 6-17
Character Data Types 6-17
Datetime Data Types 6-18
Interval Data Types 6-18
Numeric Data Types 6-18
Extended NUMERIC Precision 6-18
Floating-Point Data 6-20
Character String Data Types 6-22
Considerations for Character String Data Types 6-23
SQL/MP Considerations for Character String Data Types 6-25
Datetime Data Types 6-25
Considerations for Datetime Data Types 6-27
SQL/MP Considerations for Datetime Data Types Not Equivalent to DATE,
TIME, TIMESTAMP 6-27
SQL/MP Considerations for Datetime Data Types Equivalent to DATE, TIME,
TIMESTAMP 6-29
Interval Data Types 6-31
Considerations for Interval Data Types 6-32
SQL/MP Considerations for Interval Data Types 6-33
Numeric Data Types 6-34
DEFINEs
6-38
Using DEFINEs 6-38
Using DEFINEs From MXCI 6-40
DEFINEs of Class MAP
6-40
Expressions
6-41
Character Value Expressions 6-41
Examples of Character Value Expressions
6-42
Datetime Value Expressions
6-43
SQL/MP Considerations for Datetime Value Expressions
6-44
Considerations for Datetime Value Expressions
6-44
Examples of Datetime Value Expressions 6-45
Interval Value Expressions
6-47
SQL/MP Considerations for Interval Value Expressions
6-49