NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-20
Deadlocks
Following are the most common errors that occur when you attempt to execute a DDL
statement on an SQL object while another DDL operation is in progress on the same
object:
Deadlocks
Deadlock is a block to data flow caused by processes contending for the same locked
data. For example, deadlock occurs when process A locks one row and waits for another
row locked by process B, while process B waits for the row locked by process A.
When deadlock causes a process to fail to acquire a requested lock within the timeout
period, one of two errors occurs:
•
Error 73 indicates the request was canceled successfully, and the transaction
continues.
•
Error 40 indicates the statement timed out after being partially executed. SQL aborts
the transaction if the error occurred during an INSERT, UPDATE, or DELETE
against a table with an index affected by the change; otherwise, the transaction
continues. (Error 40 also occurs if a statement fails to acquire a requested lock for
other reasons.)
You can control the timeout period for a table or view with CONTROL TABLE. You
can also disable the waiting for locked data and request that immediate control be
returned to SQLCI or the host program. See the discussion of TIMEOUT and RETURN
IF LOCKED under CONTROL TABLE Directive
on page C-72 for more information.
DECIMAL_POINT Option
DECIMAL_POINT is an option of the SQLCI report writer SET STYLE command that
specifies either a period or a comma as the decimal point character in numeric print
items.
File System Errors
12 File in use
40 The operation timed out
73 The table is locked
1057 Unable to access table that is being altered
NonStop SQL/MP Errors
1203 Data could not be retrieved from catalog table name
1222 The label of name could not be altered
DECIMAL_POINT { "." | "," }
The default is ".".