Problem Note 12567: "Function sequence error" issued when inserting data into DB2 8.1
Fixpack 5 or later when using columns name on the INSERT statement
The following error message may be issued when attempting to insert
data into a DB2 table that uses column names in the INSERT statement.
ERROR: CLI open cursor error: [IBM][CLI Driver] CLI0125E Function
sequence error. SQLSTATE=S1010
With the release of DB2 8.1 Fixpack 5 and later releases, IBM has
introduced a change in their CLI LOAD mechanism that prohibits the use
of column names in the INSERT statement that is used for the CLI LOAD.
Since the SAS/ACCESS to DB2 engine always uses column names in the
INSERT statement, this results in a "function sequence error" being
issued when trying to use BL_METHOD=CLILOAD with DB2 8.1 FP 5.
To workaround this problem, do not use column names on the INSERT
statement.
A Technical Support hot fix for SAS 9.1.2 (9.1 TS1M2) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/c9_sbcs_prod_list.html#012567
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | 64-bit Enabled AIX | 9.1 TS1M2 | 9.1 TS1M3 |
| 64-bit Enabled Solaris | 9.1 TS1M2 | 9.1 TS1M3 |
| 64-bit Enabled HP-UX | 9.1 TS1M2 | 9.1 TS1M3 |
| Tru64 UNIX | 9.1 TS1M2 | 9.1 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2004-06-25 09:53:59 |
| Date Created: | 2004-06-10 09:45:18 |
