column-number {,null={(start-position,[{c|x}]'comparison-value') |
Specifies in order of the definitions (ascending order) the table column number in which the input data is to be stored.
For details about the other operands, see section 5.7.1 Column name statement.
The following presents a specification example of null value/function information file. This example uses the binary format.
CREATE TABLE T1 (C1 INT,C2 DATE,C3 VARCHAR(10),C4 BLOB(100k));
1,null = '-1'
2,null = '0000-00-00'
3,null = (5,x'20')
4,null = (1,'@')
If an input file subject to data loading does not contain data for some columns, the utility stores in those table columns the default value specified in WITH DEFAULT or the null value. For details, see 5.9 Null and default values during data loading.