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 LOAD TABLE information in Chapter 6, “Moving Large Object Data” of the Large Objects Management in Sybase IQ, see “LOAD TABLE supports loading default values [CR 396843]”.