SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xvi
6. SQL/MX Language Elements (continued)
6. SQL/MX Language Elements (continued)
Logical Names for SQL/MX Objects 6-12
Physical Names for SQL/MP Objects 6-12
Logical Names for SQL/MP Objects 6-13
DEFINE Names for SQL/MP Objects 6-13
SQL/MX Object Namespaces 6-14
Considerations for Database Object Names 6-14
Data Types 6-16
Comparable and Compatible Data Types 6-16
Character String Data Types 6-20
Datetime Data Types 6-24
Interval Data Types 6-30
Numeric Data Types 6-33
DEFINEs 6-36
Using DEFINEs 6-36
Using DEFINEs From MXCI 6-38
DEFINEs of Class MAP 6-38
Expressions 6-39
Character Value Expressions 6-39
Datetime Value Expressions 6-40
Interval Value Expressions 6-45
Numeric Value Expressions 6-50
Rowset Expressions 6-53
Identifiers 6-54
Regular Identifiers 6-54
Delimited Identifiers 6-54
SQL/MP Considerations for Identifiers 6-55
Examples of Identifiers 6-55
Indexes 6-57
SQL/MP Indexes 6-57
SQL/MX Indexes 6-57
Keys 6-58
Clustering Keys 6-58
First (Partition) Keys 6-59
Index Keys 6-60
Primary Keys 6-61
SYSKEYs 6-61
Literals 6-62
Character String Literals 6-62