Skip to content

DF_DATABASE_USE_DF_LOCKERROR

Indicates what error will be generated in case of a deadlock/lock timeout error.

Level

Database

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC), revision 5 and higher.

Type

Boolean, temporary

Access

Read/Write

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_USE_DF_LOCKERROR of {driverNumber} {databaseHandle} to {BooleanVariable}
Set_Attribute DF_DATABASE_USE_DF_LOCKERROR of {driverNumber} {databaseHandle} to {True|False}

Driver Configuration Keyword

Use_DF_Lockerror

Remarks

Indicates what error will be generated in case of a deadlock/lock timeout error. If true, DFERR_LOCK_TIMEOUT (error 4106 "Locktime-out") will be generated. This will trigger the built-in automatic retry mechanism. If set to false, CLIERR_DEADLOCK_OR_TIMEOUT (error 12303 "Deadlock or timeout") will be generated.

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    Boolean bAttribValue
    Get_Attribute DF_DATABASE_USE_DF_LOCKERROR of iDriver hDatabase to bAttribValue
    Showln "Translate lock errors: " (If(bAttribValue, "YES", "NO"))
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.