DB2 FOR LUW / DB2FORLUW / A10 - DB2

This fix adds support for specifying DEFAULTIF = NULL on a field 
definition on the INGEST command.  This provides an equivalent 
to load/import modifier usedefaults.  The extension to the 
grammar of the DEFAULTIF clause on the INGEST command is as 
follows: 
 
|--DEFAULTIF-+------------+-=-+-- char--+-| 
             '-(position)-'  '-- NULL --' 
 
DEFAULTIF = NULL 
Specifies that if the field is empty, then the utility considers 
the field value to be the default value of the table column to 
which the field is assigned.  A field is considered empty if any 
of the following is true: 
 
- When the input format is DELIMITED and any of the following is 
true: 
-- There are two adjacent delimiters. 
-- There are two delimiters with only blanks between them and 
the NOTRIM option is not specified. 
-- The record ends at the end of a previous field. 
- When the input format is POSITIONAL and the record ends at the 
end of a previous field.

not known / see Local fix

This new functionality is provided in DB2 Version 10.1 Fix Pack 
5.

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.06.2015
14.07.2015
14.07.2015