Solved

How can we use IAL copy only new data.

  • 17 February 2022
  • 10 replies
  • 198 views

Userlevel 3
Badge +9

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

 

 

icon

Best answer by Oshada Samarasinghe 18 February 2022, 11:19

View original

10 replies

Userlevel 4
Badge +6

Hi @Mervan ,

 

Please refer the below thread.

 

Best Regards,

Oshada

Userlevel 3
Badge +9

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

Userlevel 4
Badge +6

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

Userlevel 3
Badge +9

@Oshada Samarasinghe 

 

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

Best regards;

Mervan

Userlevel 3
Badge +9

Thank you @Oshada Samarasinghe  :)

Userlevel 2
Badge +5

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;

Userlevel 3
Badge +9

Thank you for your answer @AHMET.GULTEKIN 

 

Best regards,

Mervan

Userlevel 6
Badge +13

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.

Userlevel 2
Badge +5

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.

Userlevel 6
Badge +13

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.

 

Reply