IBM.Data.Db2 - not fully supports Informix
Posted in 2024
Topics: Stored Procedures & SPL
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 ------------------------------
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 www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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.