• Print |
• E-mail  |
• Bookmark

Using SAS/ACCESS to ODBC or SAS/ACCESS to DB2 may result in the
following error:

  ERROR: CLI open cursor error. [IBM][CLI Driver][DB2] The cursor
     "SQLCURCS297" is not in prepared state. SQLSTATE=26501

We have patches that can be downloaded from:


  For SAS 8.1 SAS/ACCESS to ODBC & SAS/ACCESS to DB2:
    http://www.sas.com/techsup/download/pc/v81_odbc_db2_cursor_fix.zip

  For SAS 8.2 SAS/ACCESS to DB2:
    A Technical Support hot fix for this problem is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82d204

  For SAS 8.2 SAS/ACCESS to ODBC :
    A Technical Support hot fix for this problem is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82od02


In addition to applying the patches mentioned above, customers will need
to edit their DB2CLI.INI file (which is in the SQLLIB directory) by
adding CURSORBEHAVIOR=0. This statement causes DB2 to correctly report
their cursor commit behavior as close, which causes the engine to
either (1) defer the commit or (2) reprepare before calling execute.

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) for this issue is available at: