Home
SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
Guide to SQL: Tutorial
The Informix® Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Programming for a multiuser environment
How locks work
Informix® database servers support a complex, flexible set of locking features that the topics in this section describe.
Lock scope
Smart-large-object locks
Byte-range locks

SQL programming
You can use the HCL Informix® implementation of the SQL language to develop applications for Informix database servers.
- Guide to SQL: Syntax
- Guide to SQL: Reference
  The Informix® Guide to SQL: Reference contains the reference information for the system catalog tables, data types, and environment variables of the HCL Informix dialect of the SQL language, as implemented in HCL Informix. These topics also include information about the stores_demo, sales_demo, and superstore_demo databases that are included with HCL Informix.
- Guide to SQL: Tutorial
  The Informix® Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
  - Database concepts
  - Compose SELECT statements
  - Select data from complex types
  - Functions in SELECT statements
  - Compose advanced SELECT statements
  - Modify data
  - Access and modify data in an external database
  - SQL programming
  - Modify data through SQL programs
  - Programming for a multiuser environment
    - Concurrency and performance
    - Locks and integrity
    - Locks and performance
    - Concurrency issues
    - How locks work
      Informix® database servers support a complex, flexible set of locking features that the topics in this section describe.
    - Lock with the SELECT statement
      The type and duration of locks that the database server places depend on the isolation set in the application and whether the SELECT statement is within an update cursor.
    - Retain update locks
    - Exclusive locks that occur with some SQL statements
      When you execute an INSERT, UPDATE, or DELETE statement, the database server uses exclusive locks. An exclusive lock means that no other users can update or delete the item until the database server removes the lock. In addition, no other users can view the row unless they are using the Dirty Read isolation level.
    - The behavior of the lock types
    - Control data modification with access modes
    - Set the lock mode
    - Simple concurrency
    - Hold cursors
    - The SQL statement cache
    - Summary
  - Create and use SPL routines
  - Create and use triggers

Byte-range locks

You can lock a range of bytes for a smart large object. Byte-range locks allow a transaction to selectively lock only those bytes that are accessed so that writers and readers simultaneously can access different byte ranges in the same smart large object.

For information about how to use byte-range locks, see your Informix® Performance Guide.

Byte-range locks support deadlock detection. For information about deadlock detection, see Handle a deadlock.