DB2 - Problembeschreibung
Problem IC91801 | Status: Geschlossen |
IMPORT NULL VALUE TO A COLUMN THAT IS A PART OF PRIMARY KEY WITH INSERT_UPDATE AND USEDEFAULTS OPTIONS WILL COMPLAIN -206 ERROR. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
During the import with insert_update and usedefaults options, if a column is a part of the primary key and this corresponding column in the source file has no explicit column data, e.g NULL, the import command will complain as below: SQL3015N An SQL error "-206" occurred during processing. SQL0206N "DEFAULT" is not valid in the context where it is used. SQLSTATE=42703 Below are the steps of problem reproduction: 1. Create a table and primary key db2 "create table alantest (col1 varchar(10) NOT NULL, col2 varchar(10) NOT NULL DEFAULT 'HJP',col3 varchar(5) NOT NULL)" db2 "alter table alantest add primary key(col1,col2)" 2. Edit an import file named alantest.del which get the col2 had NULL value aaa,,ccc 3. For table alantest run db2 import from alantest.del of del modified by usedefaults insert_update into alantest --This will succeed. db2 import from alantest.del of del modified by usedefaults insert_update into alantest --This time it will fail with SQL3015N | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL USERS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v101FP3 to get this problem fixed. * **************************************************************** | |
Local-Fix: | |
Modify the source file to replace the NULL to an explicit value. OR Redefine the primary key -- db2 "alter table alantest add primary key(col1)" | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
The Problem will be fixed in v101FP3. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.04.2013 02.10.2013 02.10.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.3 | |
10.1.0.3 |