Alter storage characteristics

After you create a smart large object, you can change some of its storage characteristics with the mi_lo_alter() function. This function enables you to alter the logging behavior, last-access time, and extent size.

All other storage characteristics cannot be changed after the smart large object is created. For information about the syntax of the mi_lo_alter() function, see the IBM® Informix® DataBlade API Function Reference.

You can alter these storage characteristics in either of the following ways:

Execute the SQL statement, ALTER TABLE.
The PUT clause of ALTER TABLE enables you to modify any storage characteristics. However, any changes do not affect existing smart large objects; they only affect smart large objects in rows created after the ALTER TABLE statement executes. For more information, see the description of ALTER TABLE in the HCL Informix Guide to SQL: Syntax.
Call the mi_lo_alter() function.
This function enables you to modify the logging characteristics, last-access time characteristics, and the extent size.