IBM Support

IC67518: VSAI FAILS WITH INFORMIX WHEN A TABLE NAME IS SPECIFIED IN UPPERCASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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"
    

Local fix

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

Problem summary

  • ****************************************************************
    * 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.                                                  *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC67518

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-01

  • Closed date

    2010-10-08

  • Last modified date

    2010-10-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC69042

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 October 2010