SQL_BLOB_CLS_ISBTAB - SQLbcis

SQL_BLOB_CLS_ISBTAB checks whether or not a base table is a BLOB table. When the database, table and schema names are entered, the value 1 or 0 is output. If the value 1 is returned, this indicates that the table is a BLOB table. The value 0 signals syntax errors or indicates that the table is not a BLOB table.

This CLI call requires the SELECT privilege for the BLOB table.

CLI declaration in C:

void SQL_BLOB_CLS_ISBTAB( char const *TableName
          ,char const *SchemaName
          ,char const *CatalogId
          ,long int *IsBlobTable
          ,struct SQLda_t *SQLda);

CLI declaration in COBOL:

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

TableName

Name of a base table. TableName 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.

SchemaName

Name of the schema in which the base table is located. SchemaName must be 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.

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.

IsBLOBtable

Boolean value. If the value 1 is returned, this indicates that the table is a BLOB table. The value 0 signals syntax errors or indicates that the table is not a BLOB table.

SQLda

Diagnostics area.