|
The following is a behavior changes from previous versions of the software.
Load table semantics changed The LOAD TABLE command now has improved semantics if a column list is specified. A column list must specify each of the columns that exist in the file in the order in which they appear. Column names that do not appear in the list are set to NULL, zero, an empty string, or a default value, depending on the column nullability, data type, and default behavior.
Columns that exist in the input file but which are to be ignored by LOAD TABLE can be specified using the column name filler().
For more information see LOAD TABLE statement.