Status of this Function since DB2 CLI Version 5
| Note: |
In ODBC version 3, SQLSetStmtOption() has been deprecated and replaced with SQLSetStmtAttr(); see SQLSetStmtAttr - Set Options Related to a Statement for more information. Although this version of DB2 CLI continues to support SQLSetStmtOption(), we recommend that you begin using SQLSetStmtAttr() in your DB2 CLI programs so that they conform to the latest standards. See DB2 CLI Functions Deprecated for Version 5 for more information on this and other deprecated functions. |
| Note: | This deprecated function cannot be used in a 64-bit environment. For more details see Deprecated Functions Not Supported in a 64-bit Environment. |
Migrating to the New Function
The statement:
SQLSetStmtOption(
hstmt,
SQL_ROWSET_SIZE,
RowSetSize);
for example, would be rewritten using the new function as:
SQLSetStmtAttr(
hstmt,
SQL_ATTR_ROW_ARRAY_SIZE,
(SQLPOINTER) RowSetSize,
0);