Problem Note 5909: Unable to append to a SYBASE table with BULKCOPY if an identity column
exists on the table
You will receive the following error message when appending to a
SYBASE table with the BULKCOPY option if an identity column
exists in the table:
ERROR: Bulk Data Transfer Failed: sassyb:sychkmsg:Error Message
Routine FAILED.
No records will be appended to the SYBASE table.
The SAS/ACCESS engine for SYBASE attempts to bind the SAS column
corresponding to the SYBASE identity column. This is the cause of the
error message. The engine should bypass this column instead.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005909
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Sybase | Microsoft Windows NT Workstation | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| ABI+ for Intel Architecture | 8.2 TS2M0 | |
| Linux | 8.2 TS2M0 | |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 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: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Sybase
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-04-30 11:56:56 |
| Date Created: | 2001-09-21 09:52:38 |
