Levels of Inheritance for Sbspace Characteristics

The four levels of inheritance for sbspace characteristics are system, sbspace, column, and smart large objects. You can use the system default values for sbspace attributes, or override them for specific sbspaces, columns in a table, or smart large objects. Figure 45 shows the storage-characteristics hierarchy for a smart large object.

Figure 45. Storage-Characteristics Hierarchy

Figure 45 shows that you can override the system default in the following ways:

• Use the -Df tags of the onspaces -c -S command to override the system default for a specific sbspace.

  You can later change these sbspace attributes for the sbspace with the onspaces -ch option. For more information on valid ranges for the -Df tags, refer to the onspaces section in the IBM Informix Dynamic Server Administrator's Reference.

• You override the system default for a specific column when you specify these attributes in the PUT clause of the CREATE TABLE or ALTER TABLE statements.

  For more information on these SQL statements, refer to the IBM Informix Guide to SQL: Syntax.

• The programmer can override the default values for sbspace attributes for specific smart large objects with functions that the DataBlade API and ESQL/C programming interface provide.