The ifx_lo_close() function
The ifx_lo_close() function closes a smart large object.
Syntax
ifx_lo_close(lofd)Arguments
The function
accepts the following argument.
| Argument | Type | Use | Description |
|---|---|---|---|
| lofd | SQL_INTEGER | Input | Smart-large-object file descriptor |
Usage
The ifx_lo_close() function
closes a smart large object. During this function, the database server
tries to unlock the smart large object. If the isolation mode is repeatable
read or if the lock is an exclusive lock, the database server does
not release the lock until the end of the transaction.
Tip: If
you do not update a smart large object inside a BEGIN WORK transaction
block, each update is a separate transaction.