SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
xviii
6. SQL/MX Language Elements
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
Using DEFINEs From MXCI
6-40
DEFINEs of Class MAP 6-40
Expressions 6-41
Character Value Expressions
6-41
Datetime Value Expressions
6-43
Interval Value Expressions 6-47
Numeric Value Expressions
6-52
Rowset Expressions
6-55
Identifiers
6-56
Regular Identifiers
6-56
Delimited Identifiers 6-56
SQL/MP Considerations for Identifiers
6-57
Examples of Identifiers 6-57