Hi,
How can we use A copy only new data.
I couldn't find information on this topic in the ifs help documentation.
Best regards,
Mervan
Solved
How can we use IAL copy only new data.
+9Best answer by Oshada Samarasinghe
Hi
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
This topic has been closed for comments
+9Thank you for your answer.
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
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
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;
Ahmet GULTEKIN
1 person likes this
+9Thank you for your answer
Best regards,
Mervan
AHMET.GULTEKIN wrote:
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;
Hi,
what if I have only the coluns objversion and objid?
Which of these columns can I use as objdate?
Thank you.
Hi
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.
AHMET.GULTEKIN wrote:
Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.