SQLSetStmtOption function (CLI) - Set statement option

In ODBC 3.0, SQLSetStmtOption() has been deprecated and replaced with SQLSetStmtAttr(). Although this version of CLI continues to support SQLSetStmtOption(), use SQLSetStmtAttr() in your CLI programs so that they conform to the latest standards.

Migrating to the new function

Note: This deprecated function cannot be used in a 64-bit environment.

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);