HP Neoview Release 2.5 Software - Manual (Page 149)

3. Click the Control Query Defaults tab.
4. Click [ Add ] or [ Modify ].
5. In the CQD Name field, enter a new name or change the existing name.
6. In the Value field, enter a new CQD value, or change the current value.
NOTE: The names and values entered manually cannot be checked for validity at the time
of entry. They are validated at execution time only.
Use the Controlled Tables Tab
The Controlled Tables Tab allows you to manipulate certain options for specific tables:
Description Option
The table name. Name
Determines the result if you attempt to access data with read committed or serializable access and
the data is locked by another user. If-Locked
Specifies whether to use MDAM (MultiDimensional Access Method) for subsequently compiled
DML (Data Manipulation Language) statements that access the index. MDAM
Specifies the priority for subsequent file system requests to DAM. DAM 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 applies to tables only, not views. Similarity Check
Determines whether to use table locks for subsequently compiled DML statements that access the
table or view. Table Lock
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.
NOTE: This timeout applies to static operations only.
Timeout
If-Locked Option of Controlled Tables Tab
Description Value
The value used is the system default setting that exists at execution time.
Returns the file-system error 73. For more information about file-system errors, see the Neoview Messages
Manual. Return
Neoview SQL waits for another user to release the lock, until the timeout period elapses. Wait
MDAM Option of Controlled Tables Tab
Description Value
The value used is the system default setting that exists at execution time.
Neoview SQL determines whether to use MDAM. This is the default. Enable
Do not use MDAM. Off
Use MDAM. On
Create a Data Source 149