Skip to content
≡

Administrator

Developer

Tools

External Tools

SQLFreeLob

SQLFreeLob#

SQLFreeLob releases resources that are related to a LOB locator opened during the current transaction.

Syntax#

SQLRETURN SQLFreeLob (
    SQLHSTMT        stmt,
    SQLUBIGINT      locator);

Arguments#

Data Type Argument In/Out Description
SQLHSTMT stmt Input Handle for the found results
SQLUBIGINT locator Input LOB Locator

Return Values#

SQL_SUCCESS
SQL_INVALID_HANDLE
SQL_ERROR

Description#

Reports that operation of LOB pointed by a LOB locator is complete. This will release the LOB locator assigned by a server and other related resources in the server.

This function does not commit or rollback changes to LOB pointed by a LOB locator.

If a transaction is terminated with SQLEndTran(), a LOB locator is automatically released and this function does have to be called.

Diagnosis#

SQLSTATE Description Comments
08S01 Communication link fault (Data transmission failure) Communication link failed before function processing is complete between Altibase CLI driver and DB.
HY000 General error 
SQLGetLobLength
SQLGetLob
SQLPutLob

Example#

Please see the examples of SQLGetLobLength(), SQLGetLob() and SQLPutLob().