• Print |
• E-mail  |
• Bookmark

If you attempt to insert/append to a Sybase table using PROC DBLOAD with
existing rows in the table that have the same primary key as those being
inserted, those rows are not inserted and no error messages are issued.
The log indicates everything was inserted, but many (or all) rows were
rejected.

This problem occurs only during a bulk copy operation from within either
DBLOAD or LIBNAME output append processing.  On errors of primary key or
unique index violation, these errors were not being surfaced. This is a
SAS bug and has been fixed with SAS Version 8.2.

Below is some sample code that will replicate the problem:

   proc sql;
   connect to sybase (user='user' password='password');
   execute (create table foobar (col1 x  tinyint primary key)
       by sybase;
   execute (insert into foobar values (1)) by sybase;
   quit;

   data one; x=1; run;
   data two; x=999999999999; run;

   proc dbload dbms=sybase data=one append;
   user='austin'; password='austin';
   table = 'foobar1';
   bulk=yes;
   load;
   run;

   proc dbload dbms=sybase data=two append;
   user='austin' ; password='austin';
   table = 'foobar2';
   bulk=yes;
   load;
   run;

Operating System and Release Information