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