DB2 FOR LUW / DB2FORLUW / 970 - DB2

VSAI does not work with Informix because if the tables or users 
are case sensitive. 
 
For example: 
 
Running the following as "informix" 
-------- 
drop table "informix"."T1"; 
create table "informix"."T1"(C1 int not null primary key); 
insert into "informix"."T1" select tabid from systables; 
select tabname,owner from systables where tabname='T1'; 
-------- 
 
Results in the following error within Microsoft Visual Studio: 
 
Some updating commands could not be generated automatically. The 
database returned the following error: ERROR 
[42000][IBM][IDS/NT64] The specified table (informix.t1) is not 
in the database. (-111 ISAM error: No record found.) 
 
VSAI is searching for "informix.t1" but the table is "T1" 
with an uppercase "T"

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of IBM Database Add-Ins for Visual Studio              * 
* withIBMInformix Online Dynamic Server version 11.10 or       * 
* greater                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The IBM Database Add-Ins for Visual Studio 9.7 (VSAI)doesnot * 
* work with Informix databases because Informixtablenames and  * 
* userids are case sensitive.  VSAI doesnotrecognize uppercase * 
* tablenames and will generate anerror.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IBM Database Add-Ins for Visual Studio 9.7        * 
* FP3orlater.                                                  * 
****************************************************************

The only workaround I see is to specify all identfiers as 
lowercase.

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in IBM Database Add-Ins for Visual Studio Version 
9.7 fix pack 3.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC69042 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

01.04.2010
08.10.2010
08.10.2010

9.7.,
9.7.FP3