Hi @Mervan ,

Please refer the below thread.

Best Regards,

Oshada

Thank you for your answer. @Oshada Samarasinghe 

I've seen this before but I don't understand. I just want to use the copy only new data field.(option 3)

Best regards,

Mervan

Hi @Mervan ,

According to the documentation, In the Copy only new-data (fast access) option,  Only data that is new since the last replication will be copied, to improve the performance. To use this option, a date type column named 'objdate' needs to be present in the Select statement of the IAL Object from which the new data would be identified since the last replication.

Best Regards,

Oshada

@Oshada Samarasinghe 

Yes I know that, I don't know how to do it in practice.

Best regards;

Mervan

Thank you @Oshada Samarasinghe  :)

The new data is filtered with objdate field. So in your example you can use rowversion as objdate to add or modify your data collection with newly changed/created company person records.

SELECT company_id, person……, rowversion objdate from &AO..company_person_tab;

Thank you for your answer @AHMET.GULTEKIN 

Best regards,

Mervan

Hi,

what if I have only the coluns objversion and objid?

Which of these columns can I use as objdate?

Thank you.

Hi @Link,

You should check whether rowversion columns data type is date on your table, if it is then possibly you can use objversion as objdate with casting, while it is casted into string from rowversion.

OK, thanks.

It is already a string. I am going to create an IAL for history logs.