The HP Neo ODBC driver has a bug in that when you try and do a "SELECT..FOR UPDATE" query (which SAS/ACCESS to ODBC does as part of it's UPDATE/DELETE operations) it will return an error similar to the following:

DIAG [42000] [HP][HP ODBC Driver][SQL Database] SQL error:***
ERROR[4118] The
cursor query expression is not updatable. (-4118)
DIAG [X08MU] [HP][HP ODBC Driver][SQL Database] SQL error:***
ERROR[8822] The
statement was not prepared. (-8822)

In essence, the driver ignores the setting of TXN_ISOLATION at run time. The next rev of their driver will default to READ_COMMITTED (it currently defaults to READ_UNCOMMITTED).

We have a hotfix to provide this workaround for now so that any early adopters of the HP Neo system can use SAS with it.

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :