An error can occur when you try to insert rows (that are in a different order than they appear in the SAS data set and DB2 table) into DB2. If you are using the BULKLOAD=YES option, it will not generate any errors. Instead a message appears saying that the rows were loaded. However, if you look at the table, you will see that the rows were not inserted in the table. No errors or warnings appear in the bl_log or bl_exception logs, either. This lack of error propagation can be misleading.

To work around this issue, do one of the following:

• Remove the BULKLOAD=YES option.
• Reorder the variables so they are in the same order as in the SAS data set and the DB2 table.

The insertion should work fine after you use one of these workarounds.

Another issue can also occur. The following artificial error message for CLILOAD might be issued when you insert fewer columns than exist in the target table that has DB2 IDENTITY columns:

unable to initialize bulkloader

To work around this issue, insert the same number of columns as there are in the table.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: