Hi All,
Wondering someone would help explaining me that Y proc append doesnt throw an error when loading in to DB2 table where they have constraints. I tried to append a existing row in to DB2 table, it doesnt throw me unique constraint error rather it is throwing 1 rows loaded and 1 rows deleted, due to this my job doesnt get exit.
proc append base = libref.tablename( BULKLOAD = YES
BL_METHOD=CLILOAD )
data = sastable force ;
run;
1 rows loaded.
0 rows skipped.
0 rows rejected.
1 rows deleted as duplicates.
1 rows committed.