5.8.1 Column number statement

Organization of this subsection
(1) Format
(2) Operands
(3) Specification example
(4) Notes

(1) Format

column-number {,null={(start-position,[{c|x}]'comparison-value')
          |'numeric-comparison-value'}
                    [,element=elements-count][,elmtype=arrayed-data-format][,nullset=null-value-option]
          |,func=(function-name,param=argument-type
            [,null={start-position,[{c|x}]'comparison-value')
            |'numeric-comparison-value'}][,...])}
       |,sequence=([authorization-identifier.]sequence-generator-identifier
         [,replace={'numeric-comparison-value'|(begin-position,{c|x}'comparison-value')|null|force}])
         }

(2) Operands

(a) column-number
~<unsigned integer> ((1-30000))

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.

(b) Other operands

For details about the other operands, see section 5.7.1 column-name statement.

(3) Specification example

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));

Explanation
The null value is stored if the data corresponding to each column is the following value:
C1: 0xffffffff
C2: 0x00000000
C3: 0x000a61626364202020202020
C4: 0x0000000140

(4) Notes

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.