SQLAllocEnv is deprecated

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQLAllocEnv is deprecated

jtuchel
I guess Instantiations is aware of this, but I thought I'd share what I just read on IBM's online documentation for the rather old (and soon to be unsupported) DB2 9.1:
 

QLAllocEnv function (CLI) - Allocate environment handle

Deprecated
Note:

In ODBC 3.0, SQLAllocEnv() has been deprecated and replaced with SQLAllocHandle().

Although this version of DB2 CLI continues to support SQLAllocEnv(), we recommend that you use SQLAllocHandle() in your DB2 CLI programs so that they conform to the latest standards.

Migrating to the new function

The statement:

   SQLAllocEnv(&henv);

for example, would be rewritten using the new function as:

   SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);


In another thread on this forum I just posted about a problem with this API call.
My problem surely is not related to this deprecation, because I can use the same code on another machine, but I wanted to mention the deprecation here.
Since I am using DB2 9.7, it seems the function is still supported, but maybe soon it isn't. This seems to affect ODBC as well.

Joachim

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/va-smalltalk/-/Qspk74_aD-cJ.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/va-smalltalk?hl=en.