Load value as current timestamp

guptae · Posted: Mon Nov 30, 2009 4:35 pm Post subject: Load value as current timestamp

Hi All,

I need to load a table which contain a timestamp field which defind as

VERSION_NUMBER char(5)
CREATION_TS timestamp not null

Now problem is my data file contain some other dats while loading i wanted to load the data with current timestamp

So if file contain data as

sushanth bobby · Posted: Mon Nov 30, 2009 6:25 pm Post subject:

Guptae,

Its possible using FASTLOAD utility without ALTERing you table.

But with LOAD utility, you have to ALTER the table for that column to NOT NULL WITH DEFAULT. Then you can ignore the column in the LOAD card, automatically CURRENT TIMESTAMP will be taken.

Thank You,
Sushanth