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.