JL Rich 16.Dec.08 09:51 AM a Web browser LEI LEI - 6.5 iSeries
I am using LEI (not sure what version because not sure how to check) on an AS400. I have a DB2 to Notes replication activity that always inserts duplicates for most of my documents. The primary key that I am using is a product number that has alpha characters, digits and periods in it so I know that it is the sorting of the key that is causing the problem but I have been unable to fix it.
I also have another replication activity that is DB2 to Notes and out of 1200 documents it always update 370 of them. This one has a primary key that is a number so it should not cause a problem.
I have read what is on this forum about the same and have tried using an order metaconnector sorting by binary. I have also tried the other sort options to no avail.
Can anyone suggest something? Right now, I am just using the Direct Transfer but this means updating/inserting the same documents over and over again rather than just what needs update.