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