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.
Compose SELECT statements
SELECT statement overview
Output from SELECT statements
Output from large object data types

Output from large object data types

When you issue a SELECT statement that includes a large object, DB-Access displays the results as follows:

For a TEXT column or CLOB column, the contents of the column are displayed.
For a BYTE column, the words <BYTE value> are displayed instead of the actual value.
For a BLOB column, the words <SBlob data> are displayed instead of the actual value.