DO NOT REPLY [Bug 20105] New: - DB2 populate script for generated values

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20105>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=20105

DB2 populate script for generated values

           Summary: DB2 populate script for generated values
           Product: Jetspeed
           Version: 1.4b4-dev / CVS
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Database
        AssignedTo: jetspeed-dev@jakarta.apache.org
        ReportedBy: hautekej@systemat.be


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

---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org