50234 - A "CLI prepare error" occurs when you use SAS/ACCESS ...

Problem Note 50234: A "CLI prepare error" occurs when you use SAS/ACCESS® Interface to Netezza and use more than one active statement in the same CONNECTION= option

The Netezza ODBC driver does not accept more than one active statement on the same connection. Therefore, when you use SAS/ACCESS Interface to Netezza, an error might occur if you use multiple operations in the same CONNECTION= option. For example, if you use the SHARED, SHAREDREAD, GLOBAL, and GLOBALREAD operations in the CONNECTION= option and attempt to open very large tables that display the table in grid fashion (such as with SAS ^® Enterprise Guide ^® or SAS Explorer), this error might occur:

ERROR: CLI prepare error: More than one active
statements is not yet supported on the same connection SQL statement:
SELECT  "ACTUAL" FROM XXX..PRDSALE03.

This behavior is a result of a Netezza limitation.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
Product Family	Product	System	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Netezza	Microsoft® Windows® for x64	9.2 TS2M3
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	9.2 TS2M3
		Microsoft Windows Server 2003 for x64	9.2 TS2M3
		Microsoft Windows Server 2008	9.2 TS2M3
		Microsoft Windows Server 2008 for x64	9.2 TS2M3
		Microsoft Windows XP Professional	9.2 TS2M3
		Windows 7 Enterprise 32 bit	9.2 TS2M3
		Windows 7 Enterprise x64	9.2 TS2M3
		Windows 7 Home Premium 32 bit	9.2 TS2M3
		Windows 7 Home Premium x64	9.2 TS2M3
		Windows 7 Professional 32 bit	9.2 TS2M3
		Windows 7 Professional x64	9.2 TS2M3
		Windows 7 Ultimate 32 bit	9.2 TS2M3
		Windows 7 Ultimate x64	9.2 TS2M3
		Windows Vista	9.2 TS2M3
		Windows Vista for x64	9.2 TS2M3
		64-bit Enabled AIX	9.2 TS2M3
		64-bit Enabled HP-UX	9.2 TS2M3
		64-bit Enabled Solaris	9.2 TS2M3
		HP-UX IPF	9.2 TS2M3
		Linux	9.2 TS2M3
		Linux for x64	9.2 TS2M3

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

A fix for this issue for SAS/ACCESS Interface to Netezza 9.3_M1 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/J38.html#50234

A fix for this issue for SAS/ACCESS Interface to Netezza 9.3 is available at:

https://tshf.sas.com/techsup/download/hotfix/HF2/H52.html#50234

A fix for this issue for SAS/ACCESS Interface to Netezza 9.22_M2 is available at:

http://ftp.sas.com/techsup/download/hotfix/HF2/B81.html#50234

ERROR: CLI prepare error: More than one active statements is not yet supported on the same connection SQL statement

Type:	Problem Note
Priority:	medium

Date Modified:	2013-07-24 09:31:56
Date Created:	2013-06-19 16:46:46

This content is presented in an iframe, which your browser does not support. To view the RateIT tab, click here.