DB2 10.5 for Linux, UNIX, and Windows

SQLGetStmtOption function (CLI) - Return current setting of a statement option

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

Migrating to the new function

The statement:

   SQLGetStmtOption(hstmt, SQL_ATTR_CURSOR_HOLD, pvCursorHold);

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

   SQLGetStmtAttr(hstmt, SQL_ATTR_CURSOR_HOLD, pvCursorHold,
                  SQL_IS_INTEGER, NULL);