Sybase IQ now supports column default values in addition to the AUTOINCREMENT/IDENTITY default. Column default value support applies to the following commands:
LOAD TABLE
INSERT...VALUES
INSERT...SELECT
INSERT...LOCATION
UPDATE
SELECT...FROM...FOR UPDATE
You can use the CREATE TABLE statement to create column defaults at the time a table is created, ALTER TABLE to add or modify a column default value in an existing table, and CREATE DOMAIN to specify column default values in a user-defined domain (data type).
From more information on the types of constant expressions allowed for column default values and their use, see “Using column defaults” in Chapter 9, “Ensuring Data Integrity” of the Sybase IQ System Administration Guide and CREATE TABLE statement, ALTER TABLE statement, CREATE DOMAIN statement, and LOAD TABLE statement in Chapter 6, “SQL Statements” of the Sybase IQ Reference Manual.
