SQL_BLOB_VAL_LEN - SQLbvle

When the REF value and database name are entered, SQL_BLOB_VAL_LEN determines the length of a BLOB value and displays this.

The SQL_BLOB_VAL_LEN call requires the SELECT privilege for the BLOB table.

CLI declaration in C:

void SQL_BLOB_VAL_LEN( char const *REFvalue
          ,char const *CatalogId
          ,long int *ValueLength
          ,struct SQLda_t *SQLda);

CLI declaration in COBOL:

IDENTIFICATION DIVISION.
PROGRAM-ID. SQLbvle IS PROTOTYPE.
DATA DIVISION.
LINKAGE SECTION.
   01 REFvalue PIC X(237).
   01 CatalogId PIC X(31).
   01 ValueLength PIC S9(9) COMP.
   COPY SQLCA.     *> for group item SQLda.
PROCEDURE DIVISION USING REFvalue, CatalogId, ValueLength, SQLda.
END PROGRAM SQLbvle.

REFvalue

The REF value of the BLOB. The exact structure of REF values is described on "Column definitions".

CatalogId

Unqualified name of the database in which the table is located. CatalogId is an unqualified name (see section "Unqualified names"). If necessary, this name must be padded with blanks up to a length of 31 characters or terminated with a null byte. If you wish to use the default database name, simply enter a null byte or a string of blanks instead of the database name.

ValueLength

Length of the BLOB value.

SQLda

Diagnostics area.