Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

IBM.Data.Db2 - not fully supports Informix

  • 1.  IBM.Data.Db2 - not fully supports Informix

    Posted Tue November 05, 2024 11:22 AM

    Hello,

    according to offical docs I am using the IBM.Data.Db2 Nuget Package to connect my .net Core Application to Informix Servers,

    all in all this works, next to some little drawbacks like issues when using short variables in Query, but that was okay, as long as I had a way to fix it.

    But now I am facing a issue, where I do not have any plans how I can resolve this.

    When I want to execute a stored procedure th DB2Command always generates the DB2 Syntax containing "CALL XXX" instead of the Informix like syntax "Execute Procedure XXX", has anyone faced this issue, too, and has a plan how I could resolve this?

    Thanks in advance

    Andree



    ------------------------------
    Andre Emmerichs
    ------------------------------


  • 2.  RE: IBM.Data.Db2 - not fully supports Informix

    Posted Tue November 05, 2024 01:06 PM
    Andre:

    The recommendation to use the DB2 .NET driver over the Informix driver is an old one. It was instituted when the DB2 driver was more stable and also supported a later .NET release version. As far as I am aware, the current Informix driver is more up-to-date than the current DB2 driver and, of course, better supports Informix features. You should upgrade to the latest CSDK and try the Informix driver.

    Art

    Art S. Kagel, President and Principal Consultant
    ASK Database Management


    Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference.  Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.






    Original Message


Related Content