Search code examples
javasqlderby

Import data in derby with identity id

I am importing data to derby using SYSCS_IMPORT_DATA. My table has an identity columns that i want to keep because it is referenced in other tables.

I keep getting the error:

Attempt to modify an identity column

using the following call

CALL SYSCS_UTIL.SYSCS_IMPORT_DATA (NULL,'TABLE',NULL,NULL,'DATA.DEL',NULL,NULL,NULL,0);
Solution

  • Well, i found my answer. The problem was the table, just changed the GENERATED ALWAYS for GENERATED BY DEFAULT.