Changing the -Df Settings

As the database server administrator, you can override or change the -Df default settings in one of the following ways:

  • To change the default settings for an sbspace, use the onspaces -ch option. For more information, refer to onspaces -ch: Change sbspace default specifications.
  • To override the following -Df default settings for a specific table, use the SQL statements CREATE TABLE or ALTER TABLE:

    For more information on the ALTER TABLE and CREATE TABLE statements, see the HCL Informix Guide to SQL: Syntax.

The programmer can override these -Df default settings with DataBlade API and Informix® ESQL/C functions. For information about altering storage characteristics of smart large objects, see the HCL Informix DataBlade API Programmer's Guide and the HCL Informix Enterprise Replication Guide.

Copyright© 2020 HCL Technologies Limited