Altering 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 following storage characteristics:

• Logging behavior
• Last-access time
• Extent size

All other storage characteristics cannot be changed once the smart large object is created. For information on 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 IBM 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.