home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IC99134 Status: Geschlossen

INSERTING FROM AN EXTERNAL TABLE INTO A REGULAR TABLE CONTAINING A TEXT
COLUMN WITH A NULL CONSTRAINT CAN RETURN ERROR 391

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
Consider a regular table with a not null constraint for the text 
column. 
If you try to use export and import data from this table by 
creating an external table, inserting form the regular 
table into the external table and then inserting the same data 
back into the orignal table, this last insert 
will fail with a 391 error, when the blob contains an empty row. 
If you however unload the data from the regular table and use 
this unload in the creation of the external table, 
the data can be inserted back into the regular table.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* external table users having empty strings in BLOB TEXT       * 
* columns                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 12.10.xC5 or earlier PID if available             * 
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
03.02.2014
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC5
Problem behoben lt. FixList in der Version
12.10.xC5 FixList
12.10.xC5.W1 FixList