SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-18
Data Control Language (DCL) Statements
Within an MXCI session, use the SHOWCONTROL command 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 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.
For more information about the CONTROL TABLE directive, see the
SQL/MX
Reference Manual.
Table 4-3. CONTROL TABLE Directives
SQL/MP CONTROL
TABLE Directives
Implemented
in SQL/MX? Comments
ACCESS PATH Changed Use CONTROL QUERY SHAPE to force access
paths. See Forcing Query Execution Plans
on
page 4-59.
JOIN METHOD Changed Use CONTROL QUERY SHAPE to force join
methods. See Forcing Query Execution Plans
on
page 4-59.
JOIN SEQUENCE Changed Use a CONTROL QUERY DEFAULT setting,
JOIN_ORDER_BY_USER, to define join sequence.
You can also use CONTROL QUERY SHAPE to
force join sequence. See CONTROL QUERY
Directives on page 4-19.
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