home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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