[JS1-321] [FIX] DB2 populate script for generated values

• Type: Bug
• Status: Open
• Resolution: Unresolved
• Affects Version/s: 1.4b4-dev / CVS
• Component/s: Database
• Environment: Operating System: All; Platform: All
• Bugzilla Id: 20105
• Assignee: Unassigned
• Reporter: Jeroen Hautekeete
• Created: 21/May/03 16:12
• Updated: 16/Feb/11 21:04

Description

DB2 doesn't let the populate script specify values for generated columns.

SQL0798N

specified values must be replaced by "DEFAULT"

e.g.

INSERT INTO TURBINE_PERMISSION VALUES (DEFAULT,'view',NULL);
INSERT INTO TURBINE_ROLE ...
INSERT INTO TURBINE_GROUP ...
INSERT INTO TURBINE_USER ...
...
INSER INTO COFFEES