Problem Note 10867: Unable to update a Sybase table with an Identity field with SAS V8.2
When using SAS/Access Interface to Sybase 8.2 with the Access libname
engine and attempt to update a Sybase table that contains an identity
column, it will fail with:
ERROR: Error in results set for Update. Error Code: -584 Explicit value
specified for identity field in table 'x' when 'SET IDENTITY_UPDATE' is
OFF.
So tried adding dblibinit= option to libname statement for Set Identity
Update tablename on, for example:
libname x sybase user=dbitest pw=dbitest server=Sybase119
DBLIBINIT="SET IDENTITY_INSERT kgidnt ON";
and it also failed with:
ERROR: The LIBNAME statement failed. The DBLIBINIT=<command> option
failed with this message:
Error Code: -195 'IDENTITY_UPDATE' is not a recognized SET command..
ERROR: Error in the LIBNAME statement.
This is fixed in SAS 9.1.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#010867
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Sybase | Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Microsoft Windows XP Professional | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
*
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: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> Sybase
|
| Date Modified: | 2003-10-29 08:25:23 |
| Date Created: | 2003-09-18 11:07:58 |
