Incremental Table Upload

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level« 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