I'm using DB2 version 10. I have a table with a timestamp for updates defined for me as follows in the Create Table statement :
Update_Timestamp For Column D2TIMSTU Timestamp DEFAULT NULL
SQL State: 42703
Vendor Code: -206
Message: [SQL0206] Column or global variable DEFAULT not found. Cause . . . . . . : DEFAULT was not found as a column of table *N in *N and was not found as a global variable in *N.
Same error for NULL - replacing NULL for DEFAULT in the error message.
First, are you sure that col3 in the destination table is allowed to accept NULL values ?
If so, try something like this (I cant test--I dont have access to a DB2 system anymore)
INSERT INTO [Table Name](col1, col2, col3)SELECT Value1, Value2, cast(NULL as timestamp) FROM [Source Table]