• Print |
• E-mail  |
• Bookmark

The following error message may be issued when using SAS/ACCESS
Interface to DB2:

   ERROR: CLI open cursor error: [IBM][CLI Driver] CLI0125E  Function
   sequence error. SQLSTATE=S1010

The problem lies with the DB2 CLI reporting their COMMIT behavior as
CLOSE instead of PRESERVE, which is why the FUNCTION SEQUENCE ERROR is
issued and SAS incorrectly handles close/delete cursor behaviors.

This problem can be circumvented at SAS 8.1 by doing the following:

1) In the db2cli.ini, add CURSORHOLD=0 to the database being used.

2) Apply a patch to SAS 8.1.  There is a tar file,
   db2_cursor_fix.tar, that can be downloaded from our FTP
   site /techsup/download/maint/access/db2/AIXR/8.10. You will
   need to change directory to !SASROOT/sasexe and rename the
   following files with an extension such as .orig:
     sasdblda
     sasdblpa
     sasdbu
     sasdbub
     sasdbudb
     sasiodbu

   You will then need to untar the file and copy these files
   to the !SASROOT/sasexe directory.

This is an IBM problem.  Development has opened the IBM PMR# 46948,519.
IBM states this is fixed in DB2 v7 fixpack 4.  However, they have not
provided a solution for DB2 v5 and v6 users.

SAS has provided the following HOTFIX at SAS V8.2 to circumvent the IBM
problem.  However, you *MUST* be at DB2 V7 FIXPACK 4 with the HOTFIX to
resolve the problem

V8.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

V8.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

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: