18.8.3 Technical Implementation Details

The LANSA Database Layer will use LOCK_TYPE=C to set a lock timeout for all databases except Oracle – Oracle requires the timeout to be set in ORAODBC.INI. Soon after the connection is created to the database, the command setting in CMD_LOCK_TIMEOUT will be executed on the connection.

For LOCK_TYPE=S, all databases will append the value in CMD_LOCK_TIMEOUT to the selects performed before UPDATE and DELETE. These statements are flagged by the OAM using  pX_Ids->chOAMRqsType |= X_LOCK_OPERATION. This has only been tested with Oracle so far.