The ifx_lo_stat_refcnt() function
The ifx_lo_stat_refcnt() function retrieves the number of references to a smart large object.
Syntax
ifx_lo_stat_refcnt(lostat, refcount)
Arguments
The function accepts the following
arguments.
Argument | Type | Use | Description |
---|---|---|---|
lostat | SQL_INFX_UDT_FIXED | Input | Smart-large-object status structure |
refcount | SQL_INTEGER | Output | Number of references to a smart large object. This value is the number of database columns that refer to the smart large object. |
Usage
The ifx_lo_stat_refcnt() function retrieves the number of references to a smart large object.
A
database server can remove a smart large object and reuse any resources
that are allocated to it when the reference count for the smart large
object is zero and one of the following events occurs:
- The transaction in which the reference count is decremented to zero commits.
- The connection during which the smart large object was created
terminates, but the reference count is not incremented.
The database server increments a reference counter when it stores the smart-large-object pointer structure for a smart large object in a row.