Hi,

I am going to be writing code to schedule an export from one database, transfer the data via ftp/http/file copy to another system and then have that second system import the data.

The data I am moving is all from a single table, I want to do something like :

1 - export all data from table A where ADDED_TIMESTAMP>LAST_EXPORT_DATE to a CSV
2 - my code uploads to destination
3 - Target system uses TIB_IMPORT to load the CSV into the table.

All seems ok to me except that the table in question has a surrogate key provided from a generator.

There also will be many systems uploading files to the central target system in the manner described.

Is there a way to say to the TIB_IMPORT on the central target system :

"Load all the data from this CSV but don't load the TABLE_ID column, instead get a value for it from Generator X".

Apologies if that's not clear.

Cheers
Sam H