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.
For syntax and usage updates to the section “LOAD TABLE statement” in Chapter 6, “SQL Statements” of the Sybase IQ Reference Manual, see “LOAD TABLE supports loading default values [CR 396843]”.