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 |