Is there any way to get the structure of the SQLCA (SQL Communication Area) for a Informix connection.
I need to get the offset syntax error for executed statement, or is there another way to recover the position of the error using the informix driver. NET?
Thank you very much.
This topic has been locked.
6 replies Latest Post - 2012-05-16T00:45:49Z by mferia
Pinned topic GET SQLCA In C# using informix.NET Driver
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-05-16T00:45:49Z at 2012-05-16T00:45:49Z by mferia
Re: GET SQLCA In C# using informix.NET Driver2012-05-15T14:45:20Z in response to mferiaHi andreasl.
Thanks for the info, but this is for Genero language and I need for .NET
I searched the Informix documentation and I have not really found anything that can help me check the SQLCA in C #.
I have an application developed in Delphi which I want to migrate to. NET.
In this application, consult the SQLCA through isqlt09b.dll I use the library.
From what I read, the provider. NET really is a wrapper for ODBC libraries, which does not provide functionality to query the information from the SQLCA structure.
Re: GET SQLCA In C# using informix.NET Driver2012-05-15T16:13:28Z in response to SystemAdminI try it once more:
The code always disappears, will omit the surrounding square brackets.
System.Runtime.InteropServices.DllImport("isqlt09a", CharSet = System.Runtime.InteropServices.CharSet.Ansi, CallingConvention = System.Runtime.InteropServices.CallingConvention.Cdecl)
public static extern int ifx_putenv(string value);
Re: GET SQLCA In C# using informix.NET Driver2012-05-16T00:45:49Z in response to SystemAdminI found in IBM.Data.Informix.dll the next function:
this is part of db2app.dll
I will review it and I tell them the results.
Still, if anyone has used it, would appreciate your comments.