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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-47
CONTROL TABLE Statement
OFF
directs NonStop SQL/MX not to use MDAM.
PRIORITY 'priority-value'
specifies the priority for subsequent file system requests to the Data Access
Manager (DAM). DAM uses the priority to ensure efficient performance within a
mixed workload environment. Short-duration OLTP-type requests should specify a
higher priority than any concurrent long-duration query requests.
'priority-value'
specifies the priority, an integer value from 1 to 9. The default priority is 3. You
can use the highest possible value (9), but using this value can interfere with
SQL/MX system-level activity.
IF_LOCKED {'RETURN'|'WAIT'}
specifies the result if you attempt to access data with the READ COMMITTED or
SERIALIZABLE access and the data is locked by another user.
RETURN
returns file system error 73.
WAIT
directs NonStop SQL/MX to wait for the other user to release the lock, until the
timeout period elapses. The default is WAIT.
TABLELOCK {'ENABLE'|'ON'|'OFF'}
specifies whether to use table locks for subsequently compiled DML statements
that access the table or view.
ENABLE
directs NonStop SQL/MX to determine whether to use table locks for the
specified table or view. The default is ENABLE.
ON
directs NonStop SQL/MX to use table locks.
OFF
directs NonStop SQL/MX to not use table locks.
TIMEOUT 'timeout-value'
specifies the time in hundredths of seconds allowed to complete file system
requests from DML operations. If the time elapses before the file system can grant
a request to lock data, the DML statement fails, and NonStop SQL/MX returns an