Updating date column on import of file

[larry12]

Hello all,
I have a database table with an insert trigger that inserts a delimited file. That is not what I am having trouble with though. The table has a column named Last_Updated_DateTime. I need this field to be updated each time the new file is imported (inserted) into the database. I am trying to do this with out using triggers. I am using db2 v7. On the stated column I try to use a getDate() function but that doesn't work. Can someone please help.

Thank you in advance!!!!!!!

 

[MarcLodge]

Larry,
If you were to define the column as
DATE NOT NULL WITH DEFAULT
Would that do the trick?
Marc

 

[MarcLodge]

Or even
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP