wierd behavior in alter table

[datamodeler]

Perhaps I am blind or just dumb but I cannot figure out why this statement

alter table PROD."mchTEST" alter createdat set default current_timestamp;

produces this output

alter table PROD."mchTEST" alter createdat set default current_timestamp DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "default current_timestamp" was found following "alter createdat set". Expected tokens may include: "<space>". SQLSTATE=42601

Can someone please tell me what I am doing wrong?

 

[blom0344]

This is a DDL statement. Did you try and execute it from - for instance - command center?

Ties Blom