Hey,

I'm trying to run this statement on a SA16 database:

ALTER TABLE dba.image_type 
ADD lu_pit timestamp DEFAULT current timestamp, 
ADD lu_user varchar(8) DEFAULT '', 
ADD cre_pit timestamp DEFAULT current timestamp, 
ADD cre_user varchar(8) DEFAULT '';

And I get this error:

Could not execute statement.
Internal database error *** ERROR *** Assertion failed: 201200
(16.0.0.1324)
Did not expect to continue row segment -- transaction
rolled back
SQLCODE=-301, ODBC 3 State="HY000"
Line 1, column 1
You can continue executing or stop.

The database was originally a SA9 database, unloaded and reloaded in SA16. I've ran the Validate Database and it has come up clean.

Interestingly, if I separate the ADD statements it will run without error:

ALTER TABLE dba.image_type ADD lu_pit timestamp DEFAULT current timestamp;
ALTER TABLE dba.image_type ADD lu_user varchar(8) DEFAULT ''; 
ALTER TABLE dba.image_type ADD cre_pit timestamp DEFAULT current timestamp; 
ALTER TABLE dba.image_type ADD cre_user varchar(8) DEFAULT '';

I'm not sure what to do with this now? Any ideas?

Thanks, Dan