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

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