CURRENT TIMESTAMP as Default

Pandora-Box · Posted: Thu Jun 13, 2013 9:34 pm

Hi all,

As a one time activity I need to load a table using a file and I have a situation where the my table contains 5 fields and the file contains 4 and where the field missing is to be stored with CURRENT TIMESTAMP and Is it possible to store the CURRENT TIMESTAMP value to be inserted for every record from the file

My shop doesnt support CONSTANT VALUE

Is there an option to populate CURRENT TIMESTAMP for every record in the input file using LOAD UTILITY?

or Also is there an option to set the table field WITH DEFAULT CURRENT TIMESTAMP or something similar?

Akatsukami · Posted: Thu Jun 13, 2013 10:17 pm

Can the column be (re-)defined as NOT NULL WITH DEFAULT?

Pandora-Box · Posted: Thu Jun 13, 2013 11:02 pm

Yes I have control over the tables so it can be done

Pandora-Box · Posted: Fri Jun 14, 2013 12:27 pm

I felt Timstamp not needed so removed it

Thanks anyway