![WORD index and CONTAINS predicate support for character large object (CLOB) columns [CR 415547]](arrow-left.gif){kind=icon}
Sybase IQ 12.7 ESD #4 supports loading a default value into a column as specified in the LOAD TABLE statement. You can now load a default value into a column, even if the column does not have a default value defined in the table schema. The LOAD TABLE syntax includes a new DEFAULT value specification in the column specification.
The following bullets will be added to the list of column default value requirements in the section “Working with column default values” in “Using column defaults” in Chapter 9,“Ensuring Data Integrity” of the Sybase IQ System Administration Guide.
The LOAD TABLE DEFAULTS clause must be set to ON in order to use the default value specified in the LOAD TABLE statement DEFAULT value specification. If the DEFAULTS clause is OFF, the specified load default value is not used and a NULL value is inserted into the column instead.
The LOAD TABLE DEFAULT value specification must contain at least one column that needs to be loaded from the file specified in the LOAD TABLE command.
The LOAD TABLE DEFAULT default-value must be of the same character set as that of the database and must conform to the supported default values for columns and default value restrictions. The LOAD TABLE DEFAULT clause does not support AUTOINCREMENT, IDENTITY, or GLOBAL AUTOINCREMENT as a load default value.
Encryption of the default value is not supported for the load default values specified in the LOAD TABLE DEFAULT value specification.
For syntax and usage updates to the section “Bulk loading data using the LOAD TABLE statement” in Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ System Administration Guide, see “LOAD TABLE supports loading default values [CR 396843]”.
