SQL/MX 2.x Reference Manual (H06.04+)

Contents
HP NonStop SQL/MX Reference Manual—540440-003
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-19
Datetime Data Types 6-23
Interval Data Types 6-28
Numeric Data Types 6-31
DEFINEs 6-34
Using DEFINEs 6-34
Using DEFINEs From MXCI 6-36
DEFINEs of Class MAP 6-36
Expressions 6-37
Character Value Expressions 6-37
Datetime Value Expressions 6-39
Interval Value Expressions 6-43
Numeric Value Expressions 6-48
Rowset Expressions 6-51
Identifiers 6-52
Regular Identifiers 6-52
Delimited Identifiers 6-52
SQL/MP Considerations for Identifiers 6-53
Examples of Identifiers 6-53
Indexes 6-55
SQL/MP Indexes 6-55
SQL/MX Indexes 6-55
Keys 6-56
Clustering Keys 6-56
First (Partition) Keys 6-57
Index Keys 6-58
Primary Keys 6-59
SYSKEYs 6-59
Literals 6-60
Character String Literals 6-60