The system-specified storage characteristics
- If the sbspace in which the smart large object is stored has specified
a value for a particular storage characteristic, the database server
uses the sbspace value as the system-specified storage characteristic.
The database administrator (DBA) defines storage characteristics for an sbspace with the onspaces utility.
- If the sbspace in which the smart large object is stored has not
specified a value for a particular storage characteristic, the database
server uses the system default as the system-specified storage characteristic.
The database server defines the system defaults for storage characteristics internally. However, you can specify a default sbspace name with the SBSPACENAME configuration parameter of the onconfig file. Also, an application call to ifx_lo_col_info() or ifx_lo_specset_sbspace() can supply the target sbspace in the LO-specification structure.
It is recommended that you use the values for the system-specified disk-storage information. Most applications do not need to change these system-specified storage characteristics. For more information about database server and sbspace storage characteristics, see the description of the onspaces utility in your HCL OneDB Administrator's Guide.
- Use the ifx_lo_def_create_spec() function to allocate an LO-specification structure and to initialize this structure to null values.
- Pass this LO-specification structure to the ifx_lo_create_function function to create the instance of the smart large object.
The ifx_lo_create() function creates a smart-large-object instance with the storage characteristics in the LO-specification structure that it receives as an argument. Because the previous call to ifx_lo_def_create_spec() stored null values in this structure, the database server assigns the system-specified characteristics to the new instance of the smart large object.