SQL/DDL Implementation › Row Level Locking › YSQLLCK Model Value

YSQLLCK Model Value

The SQL Locking (YSQLLCK) model value lets you specify what level of locking is appropriate for your environment. It has three possible values:

• *UPD—Row locking occurs at time of update. This is the shipped default.
• *FET—Row locking occurs at time of read. Note that if no SELECT is to be performed, the lock will occur at time of update. See the Reducing the Number of SQL SELECTs section in this chapter for conditions that require a SELECT.
• *IMG—Row locking occurs at time of read. This applies only to CHGOBJ’s that are embedded in the default DBF Record’ user point of standard EDTFIL, EDTRCD(1-3), or EDTTRN functions, which will contain code that performs image compares.