You can load and insert column default values in SAP Sybase IQ.
INSERT...VALUES
INSERT...SELECT
INSERT...LOCATION
LOAD TABLE
UPDATE
SELECT...FROM...FOR UPDATE
You can specify default values that cannot be evaluated by SAP Sybase IQ. An error is reported when an INSERT, LOAD, or ALTER ADD operation is performed on a table that has an unsupported default value.
SAP Sybase IQ generates an error or warning when the server attempts to insert a default value that is incompatible with the data type of the column. For example, if you define a default expression of ‘N/A’ to an integer column, then any insert or load that does not specify the column value generates an error or warning, depending on the setting of the CONVERSION_ERROR database option.
If a default value is too long for a CHARACTER type column, SAP Sybase IQ either truncates the string or generates an exception, depending on the setting of the STRING_RTRUNCATION database option.
If the default value for a VARCHAR or LONG VARCHAR column is the zero-length string, SAP Sybase IQ inserts either a NULL or zero-length string, depending on the setting of the NON_ANSI_NULL_VARCHAR database option.
If the default value for a VARCHAR, CHAR, or LONG VARCHAR column contains a partial multibyte character, SAP Sybase IQ may trim that character before inserting the value, depending on the setting of the TRIM_PARTIAL_MBC database option.
If the default value violates the check constraint of either the table or the column, SAP Sybase IQ generates an error message every time the server attempts to insert the default value.
Constraint violations that occur during a LOAD TABLE operation as a result of inserting default values are never ignored, regardless of any user-specified IGNORE CONSTRAINT and MESSAGE LOG/ROW LOG option.
Column default values of UTC TIMESTAMP and CURRENT UTC TIMESTMAP are not supported by SAP Sybase IQ.
Column default values defined on base tables are not propagated to the joins in which these tables participate.
If a column on which a default value is defined is added to a table, all rows of the new column are populated with that default value.
Changing the default value of an existing column in a table does not change any existing values in the table.
The LOAD TABLE DEFAULTS option must be On to use the default value specified in the LOAD TABLE statement DEFAULT option. If the DEFAULTS option is Off, the specified load default value is not used and a NULL value is inserted into the column instead.
The LOAD TABLE DEFAULT specification must contain at least one column 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 option 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 clause.