Status of this Function in 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. |
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);