Using the Bulk Import and Export Utilities
Page 12 of 12

Autoincrement Defaults

You can preserve the values in the autoincrement default column by dropping the default before importing the data and then re-adding the default when you are done importing.

NOTE: If insertMode=replace, Cloudscape resets its internal counter of the last autoincrement value for a column (SYS.SYSCOLUMNS.AUTOINCREMENTVALUE) to the initial value defined for the column during bulk insert.