12567 - "Function sequence error" issued when inserting data into DB2 8.1 Fixpack 5 or later when using columns name on the INSERT statement

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

Product Family	Product	System	SAS Release
			Reported	Fixed*
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