SQL/MX Comparison Guide for SQL/MP Users

Contents
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
iv
7. Utility Differences
Tables 6-4
Clustering Keys 6-4
Table Attributes 6-4
File Types 6-4
Constraints 6-4
Indexes 6-5
Partitions 6-5
Views 6-6
SQL/MX Views 6-6
SQL/MP Views 6-6
Object Security 6-6
7. Utility Differences
DISPLAY USE OF Command 7-1
IMPORT Command 7-1
MXTOOL Utility 7-1
Partition Management: The MODIFY Utility 7-2
POPULATE INDEX Command 7-2
SHOWDDL Command 7-2
SHOWLABEL Command 7-3
Index
Figures
Figure 4-1. SQL/MP Compilation Process 4-11
Figure 4-2. SQL/MX Compilation Process 4-12
Tables
Table 2-1. NonStop SQL/MP Contents Compared to NonStop SQL/MX 2-1
Table 3-1.
Support For NonStop SQL/MP DATETIME Literals in NonStop
SQL/MX 3-6
Table 3-2. NonStop SQL/MP and NonStop SQL/MX Functions 3-9
Table 3-3. Mapping NonStop SQL/MP Datetime Functions To NonStop
SQL/MX 3-10
Table 3-4. SQL/MX and SQL/MP DML Statements 3-12
Table 3-5. CONTROL TABLE Directives 3-22
Table 3-6. Query Type Comparison 3-27
Table 4-1. Embedded SQL Statements 4-4