Lock time-out (seconds) property

Official Content
This documentation is valid for:
When accessing a locked record, it indicates the time in seconds to try to obtain the record. The value is defined in seconds; the default value is zero for all DBMS except for Oracle, which is one.

Syntax

control. Lock time-out (seconds)

The value is defined in seconds; the default value is zero for all DBMS except for Oracle, which is one.

Scope

Available at the Data Store.
Data Store: AS400, INFORMIX, ORACLE, POSTGRESQL, SQLSERVER

Description

In the case of an object with an interface, once this time has elapsed, the control is returned to the program and a message is displayed to the user for him/her to decide whether to retry or cancel the time-out.

In the case of an object without an interface: with SQL Server, PostgreSQL, it waits until the record is released; with iSeries handler, it retries for up to ten times the specified time-out and then sends a message to the system's operator.

Notes

  • This property can only be configured for iSeries, when it is used as ‘iSeries native' access technology (i.e.: generating RPG or Cobol, but not in the SQL accesses), and for SQL Server with version 7.0 or higher, with the access technologies employed by all the Client/Server generators (.NET, Java, and Visual FoxPro).
  • If the handler is iSeries, the value 0 indicates that it takes the value configured in the properties of the physical file (WAITRCD); if the handler is SQL Server, it indicates that attempts will be made indefinitely.
  • When the property is set to 0, the NoWait clause in SQL generators is not generated; it applies to objects without an interface (Procedures and Business Components).
  • PostgreSQL support is added in Xev2 Upgrade #4 (Java generator), for PostgreSQL 8.1 or higher.
  • For more details on Oracle default values, read SAC#21696

How to apply changes

To apply the corresponding changes when the property value is configured, Build any object.

See Also