Proc Append working fine in DI and not in LSF

Prakash_K — Tue, 03 Mar 2020 13:21:11 GMT

Hi All,

We are migrating netezza to Db2Cloud

In Db2 perspective we have modify the proc append code to use (BULKLOAD=YES BL_METHOD=CLILOAD)

The code works fine in DI. It appending the record properly. But the same code is rejecting the record in LSF, below are the output from Db2. Could you please advise why I got the difference ? any solution to fix in LSF?

SAS DI:

Results for CLI LOAD operation:

24560 rows loaded.

0 rows skipped.

0 rows rejected.

0 rows deleted as duplicates.

24560 rows committed.

LSF:

WARNING:

Results for CLI LOAD operation:

24559 rows loaded.

0 rows skipped.

1 rows rejected.

0 rows deleted as duplicates.

24559 rows committed.

topic Proc Append working fine in DI and not in LSF in Statistical Procedures

Proc Append working fine in DI and not in LSF