HP Integrity NonStop J-Series - Manual (Page 91)

Figure 37 Add CQD
Using the Control Table Statements tab
The Control Table Statements tab allows you to modify certain options for specific tables.
Table 26 (page 91) describes the options.
Table 26 Options in the Control Table Statements tab
Description Value
Specifies name of the table. Name
Determines the result if you attempt to access data with read committed or if you serialize access,
and the data is locked by another user. If-Locked
Specifies whether to use Multi-dimensional Access Method (MDAM) for subsequently compiled DML
statements that access the index. MDAM
Specifies the priority for subsequent file system requests to MDAM. MDAM uses the priority to ensure
efficient performance in a mixed workload environment. Priority
Specifies whether to perform similarity checks for new and previous tables to avoid statement
recompilation. This option applies only to tables. It does not apply to views. Similarity Check
Determines whether to use table locks for subsequently compiled DML statements that access the
table or view. Table Lock
Specifies the amount of time allowed to complete file-system requests from the DML operations. If the
time elapses before the file system can grant a request to lock data, the DML statement fails and
SQL/MX returns an error. Timeout
NOTE: This timeout applies to static operations only.
If-Locked
Description Value
Specifies the value used is the system default setting that exists at the time of execution.
Returns the file-system error 73. For more information on file-system errors, see the HP NonStop SQL/MX
Release 3.2.1 Messages Manual. Return
Indicates that SQL/MX waits for another user to release the lock, until the timeout period elapses. Wait
Creating a data source 91