SQL_BLOB_VAL_CLOSE - SQLbvcl

SQL_BLOB_VAL_CLOSE closes an access handle opened with SQL_BLOB_VAL_OPEN (see "SQL_BLOB_VAL_OPEN - SQLbvop").

An access handle allows you to process BLOB values sequentially. Here the calls SQL_BLOB_VAL_FETCH (see "SQL_BLOB_VAL_FETCH - SQLbvfe") for sequential reading and SQL_BLOB_VAL_STOW (see "SQL_BLOB_VAL_STOW - SQLbvst") for sequential writing are offered.

If you attempt to close an access handle that has already been closed, an error message is output.
This CLI call may require the INSERT privilege for the BLOB table.

CLI declaration in C:

void SQL_BLOB_VAL_CLOSE( char *AccessHandle
                        ,struct SQLda_t *SQLda);

CLI declaration in COBOL:

IDENTIFICATION DIVISION.
PROGRAM-ID. SQLbvcl IS PROTOTYPE.
DATA DIVISION.
   01 AccessHandle PIC X(32).
   COPY SQLCA.     *> for group item SQLda.
LINKAGE SECTION.
PROCEDURE DIVISION USING AccessHandle, SQLda.
END PROGRAM SQLbvcl.

AccessHandle

The value supplied in SQL_BLOB_VAL_OPEN for the access handle to be terminated must be entered here. This value must not be modified by the caller.

SQLda

Diagnostics area.