|
Problem IC99134
|
Status: Closed |
INSERTING FROM AN EXTERNAL TABLE INTO A REGULAR TABLE CONTAINING A TEXT COLUMN WITH A NULL CONSTRAINT CAN RETURN ERROR 391 |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.02.2014
16.10.2015
16.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC5
|
 |
| 12.10.xC5.W1
|
|
