04-06-2017 07:58 AM
I am moving the data from sas to DB2 using proc append. I use BULKLOAD, BL_METHOD and DBCOMMIT options.
I have not created any primary key on DB2 table and variable can contain null value.
While appending the data its reading all the observations from SAS datasets but its not writing all the observation into DB2 table.
I have looked into the rejected obs and I don't see any issue with the data.
NOTE: There were 10911 observations read from the data set sas_lib.abc.
NOTE: 10911 observations added.
NOTE: The data set db2_lib.abc has . observations and 12 variables.
Results for CLI LOAD operation:
10900 rows loaded.
0 rows skipped.
0 rows rejected.
0 rows deleted as duplicates.
10900 rows committed.
04-06-2017 09:47 AM
Yes, I tried using the proc sql. Still I am getting issue.
While loading I get error.
ERROR: During insert: [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003