|
Problem IC60762
|
Status: Closed |
EXECUTION OF ALTER TABLE .. ADD VERCOLS FOLLOWED BY ALTER TABLE ADD <COLNAME> BEFORE <VARCHAR COLUMN> RESULTS IN ERROR 271/151 |
| product: |
IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50 |
| Problem description: |
Following sequence of SQL statement execution will result in
SQLERROR 271, ISAM 151
1. Alter a table to add vercols, This table should contain
varchar column.
2. Insert at least one row in the table.
3. Alter the same table to add another column before a varchar
column.
4. Attempt to insert a row in this table will result in the
error. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* IDS users having tables with variable length type altered to *
* add version columns *
****************************************************************
* PROBLEM DESCRIPTION: *
* When a table with variable length type is altered to add *
* version columns, the subsequent alter causes problem in the *
* schema definition. This results into subsequent insert to *
* add incorrect data in the table *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.50.xC5 or above *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem is first fixed in 11.50.xC5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.04.2009
27.07.2009
27.07.2009 |
| Problem solved at the following versions (IBM BugInfos) |
11.50.xC5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 11.50.xC4.W1
|
 |
| 11.50.xC5
|
|
