SQL_BLOB_CLS_REF - SQLbcre

SQL_BLOB_CLS_REF returns the class REF value for the objects in a BLOB table. Input is the table and schema name.

This CLI call does not require any privileges.

CLI declaration in C:

void SQL_BLOB_CLS_REF( char const *BlobTableName
          ,char const *BlobSchemaName
          ,char *REFvalue
          ,struct SQLda_t *SQLda);

CLI declaration in COBOL:

IDENTIFICATION DIVISION.
PROGRAM-ID. SQLbcre IS PROTOTYPE.
DATA DIVISION.
LINKAGE SECTION.
   01 BlobTableName PIC X(31).
   01 BlobSchemaName PIC X(31).
   01 REFvalue PIC X(237).
   COPY SQLCA.       *> for group item SQLda.
PROCEDURE DIVISION USING BlobTableName, BlobSchemaName, REFvalue, SQLda.
END PROGRAM SQLbcre.

BlobTableName

Name of the BLOB table BlobTableName must be the unqualified table name without the database and schema names (see section "Unqualified names"). This name is case-sensitive. If necessary, this name must be padded with blanks up to a length of 31 characters or terminated with a null byte.

BlobSchemaName

Name of the schema in which the BLOB table is located. BlobSchemaName is the unqualified name of the schema excluding the database name (see section "Unqualified names"). This name is case-sensitive. If necessary, this name must be padded with blanks up to a length of 31 characters or terminated with a null byte.

REFvalue

If the CLI call executes successfully, the class REF value is returned. If this REF value is less than 237 characters in length, it is padded with blanks up to this length. The exact structure of REF values is described on "Column definitions".

SQLda

Diagnostics area.