Using the Control Table Statements tab

Name

Specifies name of the table.

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.

Specifies whether to use Multi-dimensional Access Method (MDAM) for subsequently compiled DML statements that access the index.

Specifies the priority for subsequent file system requests to MDAM. MDAM uses the priority to ensure efficient performance in a mixed workload environment.

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.

Determines whether to use table locks for subsequently compiled DML statements that access the table or view.

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.