12.2.6 Operands related to lock
- 13) pd_hb_get_lock = Y | N
- Specifies whether to lock data to be referenced by a search SQL statement. In ORACLE, a search SQL statement normally does not lock data to be referenced. Consequently, if a transaction that updates another database by referencing an ORACLE database and a transaction that updates the ORACLE database by referencing another database are simultaneously executed, the continuity of these transactions cannot be guaranteed. In this case, lock the data read from ORACLE to guarantee the continuity of the transactions.
- Y:
- Locks the data referenced by a search SQL statement. A lock is applied when a FOR UPDATE clause is specified in a SELECT statement. If Y is specified, the locked data cannot be referenced from other transactions, and as a result, the concurrent execution performance of ORACLE declines.
- N:
- Does not lock the data referenced by a search SQL statement.