Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09220 Status: Geschlossen

INGEST: DELIVER SUPPORT FOR DEFAULTIF = NULL

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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.
Problem-Zusammenfassung:
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Kommentar
This new functionality is provided in DB2 Version 10.1 Fix Pack 
5.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.06.2015
14.07.2015
14.07.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.5 FixList