INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

Creating an attached index when there is already one existing on 
the same column but with a differentiator of asc or desc will 
return error 350/108. 
 
Example: 
 
  create index i1 on t (i asc) in table; 
  create index i2 on t (i desc) in table;  <-- error 350 / 108 
returned

**************************************************************** 
* USERS AFFECTED:                                              * 
* IDS11.70 and IDS12.10 users using attached indexes           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

If "in table" is replaced by "in <dbspace>" for index i2, it 
does work as well as if both "in table" statements are removed, 
making both indexes detached. 
 
Another workaround is to add a filler in declaration of index 
i2: 
 
  create index i1 on t (i asc) in table; 
  create index i2 on t (i desc, filler) in table;

Problem Fixed In IDS-12.10.xC5

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.05.2014
16.10.2015
16.10.2015