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. A column number for a reserved column cannot be specified. If a column number for a reserved column is specified, the KFPL25103-E message is issued and pdload terminates abnormally.
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.10 Null and default values during data loading.