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 > 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:



2.Run the following:

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