Allocating statement handles in a DB2 UDB CLI application

 

SQLAllocStmt() allocates a statement handle. A statement handle refers to the data object that contains information about an SQL statement that is managed by DB2^® UDB call level interface (CLI).

The information about an SQL statement that is managed by DB2 UDB CLI includes dynamic arguments, cursor information, bindings for dynamic arguments and columns, result values, and status information (these are discussed later). Each statement handle is associated with a connection handle.

Allocate a statement handle to run a statement. You can concurrently allocate up to 160 000 handles. This applies to all types of handles, including descriptor handles that are implicitly allocated by the implementation code.

 

Parent topic:

Transaction processing task in a DB2 UDB CLI application