SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-22
CONTROL TABLE Directive
Use the MXCI command, SHOWCONTROL, to see which controls are in effect.
In NonStop SQL/MX, the CONTROL TABLE directive requires that you enclose all
arguments in single quotes. In NonStop SQL/MP, the CONTROL TABLE directive has
no such restriction.
In NonStop SQL/MP, the control TIMEOUT allows you to use a negative value (-1),
which is essentially wait forever. This value is not allowed in NonStop SQL/MX.
The NonStop SQL/MP CONTROL TABLE directive enables you to adjust the timeout
value for compile time. NonStop SQL/MX provides compile time directives for
CONTROL TABLE TIMEOUT and CONTROL TABLE STREAM_TIMEOUT. NonStop
SQL/MX provides for run-time timeout with the SET TABLE TIMEOUT statement as
described in the SQL/MX Reference Manual and SQL/MX Programming Guide for C
and COBOL.
See the SQL/MX Reference Manual for additional information about the CONTROL
TABLE directive.
Table 3-5. CONTROL TABLE Directives
SQL/MP CONTROL
TABLE Directives
Implemented
in NonStop
SQL/MX? Comments
ACCESS PATH Changed Access paths can be forced using CONTROL
QUERY SHAPE. See Forcing Query Execution
Plans on page 5-8.
JOIN METHOD Changed Join methods can be forced using CONTROL
QUERY SHAPE. See Forcing Query Execution
Plans on page 5-8.
JOIN SEQUENCE Changed Join sequence can be defined with a CONTROL
QUERY DEFAULT setting,
JOIN_ORDER_BY_USER. See CONTROL QUERY
Directive on page 3-23.
TIMEOUT Changed The SQL/MP CONTROL TABLE * TIMEOUT
statement combines the functions of the CONTROL
TABLE TIMEOUT and SET TABLE * TIMEOUT
statements.
OPEN PARTITIONS No
SEQUENTIAL No
SEQUENTIAL
BLOCKSPLIT
No
SKIP
UNAVAILABLE
PARTITION
No
SYNCDEPTH No