Each DB2 CLI function that existed in version 2 but was deprecated in version 5 is still listed in the function reference, with an indication of its state at the beginning of the function description.
Although DB2 CLI version 5 continues to support all of the deprecated functions, we recommend that you begin using the new functions in your DB2 CLI programs so that they conform to the latest standards.
In some cases the features and arguments of the deprecated function and the replacement function are very similar (SQLColAttributes() and SQLColAttribute()). In these cases the description of the deprecated function has been removed.
In other cases the description of the deprecated function has been left to assist in understanding the conversion to the new function.
The following table lists each of the deprecated function, the type of
description given, and the replacement function(s).
Table 185. Deprecated Functions and their Replacements
| Deprecated Function | Description | Replacement Function |
|---|---|---|
| SQLAllocConnect | Removed | SQLAllocHandle() |
| SQLAllocEnv() | Removed | SQLAllocHandle() |
| SQLAllocStmt() | Removed | SQLAllocHandle() |
| SQLColAttributes() | Removed | SQLColAttribute() |
| SQLError() | Unchanged | SQLGetDiagField() and SQLGetDiagRec() |
| SQLExtendedFetch() | Unchanged | SQLFetchScroll() |
| SQLFreeConnect() | Unchanged | SQLFreeHandle() |
| SQLFreeEnv() | Unchanged | SQLFreeHandle() |
| SQLGetConnectOption() | Removed | SQLGetConnectAttr() |
| SQLGetStmtOption() | Removed | SQLGetStmtAttr() |
| SQLParamOptions() | Unchanged | SQLSetStmtAttr() |
| SQLSetConnectOption () | Removed | SQLSetConnectAttr() |
| SQLSetParam() | Removed | SQLBindParameter() |
| SQLSetStmtOption () | Removed | SQLSetStmtAttr () |
| SQLTransact() | Unchanged | SQLEndTran() |