10.10.4.1. Incremental Table Upload

<< Click to Display Table of Contents >>

Navigation:  10. FAQ > 10.10. Working with Databases > 10.10.4. Securely adding rows to a database table >

10.10.4.1. Incremental Table Upload

 

The procedure given in this section guarantees to have no duplicated or lost rows when uploading rows inside a database. This procedure also allows for “Incremental Upload” where we only upload inside the database the new rows that were not there yet.

 

 
To add a a few rows (available inside a file named <source.gel_anatella>) inside the “final” Table T, we will run the following steps:
 

1.Run a “SELECT MAX(<primary_key>) FROM <Table T>” and save the result inside a “Global Parameter” named “MaxPK”: This is done this way:

 
clip0415

 

2.Run the following:
 
clip0416

3.(Optional:) Delete the (local) file <source.gel_anatella>: AN76E5~1_img365