SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

D-22

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

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. For information, see the discussion of TIMEOUT and

RETURN IF LOCKED under CONTROL TABLE Directive

on page C-77.

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.

Considerations—DECIMAL_POINT



The DECIMAL_POINT character must be a single-byte period or comma,

regardless of the character set used.



The DECIMAL_POINT option does not change the decimal point character used in

numeric literals or in mask display descriptors. That character (which is input to

SQLCI) is always a period. The DECIMAL_POINT option does change the decimal

point character that SQLCI prints in reports when you apply the mask to a value.

DECIMAL_POINT { "." | "," }

The default is ".".