Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Create and use SPL routines
Define and use variables
Declare local variables
Declare variables for smart large objects

Declare variables for smart large objects

A variable for a BLOB or CLOB object (or a data type that contains a smart large object) does not contain the object itself but rather a pointer to the object. The following figure shows how to define a variable for BLOB and CLOB objects.

Figure 1: Variables for BLOB or CLOB objects.

DEFINE a_blob BLOB;
DEFINE b_clob CLOB;