Home
Client APIs and toolsYou can use the HCL OneDB™ implementation of client APIs to develop applications for HCL OneDB™ database servers.
HCL OneDB™ ODBC Driver GuideThe HCL OneDB™ ODBC Driver Programmer's Manual serves as a user guide and reference for HCL OneDB™ ODBC Driver, which is the HCL OneDB™ implementation of the Microsoft™ Open Database Connectivity (ODBC) interface, Version 3.0.
Smart large objectsThese topics describe how to store, create, and access a smart large object; how to transfer smart-large-object data; how to retrieve the status of a smart large object; and how to read or write a smart large object to or from a file.
Storage of smart large objectsThe smart-large-object specification structure stores the disk-storage information and create-time flags for a smart large object.
Inheritance hierarchyHCL OneDB™ uses an inheritance hierarchy to obtain storage characteristics.
Using column-level storage characteristicsThe CREATE TABLE statement assigns storage characteristics to a database column.

Using column-level storage characteristics

The CREATE TABLE statement assigns storage characteristics to a database column.

About this task

The PUT clause of the CREATE TABLE statement specifies storage characteristics for a smart-large-object column. The syscolattribs system catalog table stores the column-level storage characteristics.

To use column-level storage characteristics for a new smart-large-object instance:

Procedure

Call ifx_lo_def_create_spec() to allocate a smart-large-object specification structure and initialize this structure to null values.
Call ifx_lo_col_info() to retrieve the column-level storage characteristics and store them in the specified smart-large-object specification structure.
Call ifx_lo_create() to create an instance of the smart large object.