Ignore GENERATED ALWAYS AS TRANSACTION START ID columns

[M Oenbrink]

When editing rows in a table, the UI setting (checkbox):

Tools->Options->SQL Generation->Ignore Autoincrement columns for Insert

allows bypass of some dbms auto-maintained columns from Insert statements.

DB2 supports additional auto-maintained columns options, eg:

GENERATED ALWAYS AS TRANSACTION START ID

which auto maintains a timestamp of the row's last update.

Please add coverage of this sql syntax to the Ignore for Insert checkbox ,

so that the table editor can also Insert rows into tables with such columns.

[Thomas Kellerer]

Good point, thanks.

I will exclude generated columns like that if the option is enabled.

[M Oenbrink]

Thanks for feedback Thomas.

fyi, I think in db2 you can check catalog column syscat.columns.generated for value 'A' (stands for 'ALWAYS').

[Thomas Kellerer]

Thanks. I already retrieve that information from there.

It's just not used when building the INSERT statements