I'm trying to create a table, using a SELECT state, but that also has the LOAD_USER and LOAD_DATE with defaults to CURRENT_USER and CURRENT_TIMESTAMP. If I was creating the table, then adding the data, the text for the two fields would be;
This will put the current user and date in the fields, but the fields are not set to default them going forward.
You can add constraints to the CREATE like
LOAD_USER CASESPECIFIC DEFAULT USER,
LOAD_DATE DEFAULT CURRENT_TIMESTAMP(6)
'Mickey Mouse' AS NAME
,TRANSLATE(CURRENT_USER USING unicode_to_latin) AS LOAD_USER
,CAST(CURRENT_TIMESTAMP AS TIMESTAMP) AS LOAD_DATE
But then it's quite similar to a seperate CREATE TABLE followed by a INSERT/SELECT...