SESAM-CLI

BLOB objects, their values and attributes as well as the BLOB object classes are addressed by calling the SESAM-CLI interface (Call Level Interface). CLI calls can be made from C or COBOL programs.

Below is an overview of the SESAM-CLI calls and their associated functions. The individual calls are described in detail in the “ SQL Reference Manual Part 1: SQL Statements”.

Operations involving BLOB classes

CLI call	Short form	Function
SQL_BLOB_CLS_REF	SQLBCRE	Output REF value of the class
SQL_BLOB_CLS_ISBTAB	SQLBCIS	Check whether BLOB table exists

Table 16: CLI calls for operations involving BLOB classes

Creating and deleting BLOBs

CLI call	Short form	Function
SQL_BLOB_OBJ_CREATE	SQLBOCR	Create object (object number sequential)
SQL_BLOB_OBJ_CREAT2	SQLBOC2	Create a BLOB (object number area-specific)
SQL_BLOB_OBJ_DROP	SQLBODR	Delete a BLOB

Table 17: CLI calls for BLOB objects

Reading and setting BLOB attributes

CLI call	Short form	Function
SQL_BLOB_TAG_GET	SQLBTGE	Read an attribute value
SQL_BLOB_TAG_PUT	SQLBTPU	Set an attribute value

Table 18: CLI calls for BLOB attributes

Reading and setting BLOB values

CLI call	Short form	Function
SQL_BLOB_VAL_GET	SQLBVGE	Output BLOB value
SQL_BLOB_VAL_PUT	SQLBVPU	Set BLOB value
SQL_BLOB_VAL_LEN	SQLBVLE	Output the length of a BLOB value

Table 19: CLI calls for BLOB values

Sequential processing of BLOB values

CLI call	Short form	Function
SQL_BLOB_VAL_OPEN	SQLbvop	Open an access handle
SQL_BLOB_VAL_CLOSE	SQLbvcl	Close an access handle
SQL_BLOB_VAL_FETCH	SQLbvfe	Read a BLOB value sequentially
SQL_BLOB_VAL_STOW	SQLbvst	Set a BLOB value sequentially

Table 20: CLI call for individual sequences of BLOB values