MVSFORUMS.com

monaco · Beginner Joined: 20 May 2004 Posts: 77 Topics: 31

Hi all,

i'd like to ask you a question:

i need to load a table and one of its column has a TIMESTAMP format. Is there a way when i load the table for filling in this column the current timestamp?

Kind regards.

Phantom · Posted: Fri Dec 17, 2004 10:06 am Post subject:

monaco,

This link might be useful to u.
http://www.mvsforums.com/helpboards/viewtopic.php?t=675&highlight=current+insert

Thanks,
Phantom

videlord · Beginner Joined: 09 Dec 2004 Posts: 147 Topics: 19

The link explain using SQL INSERT, but not for DB2 Utility.
If the Column define as With Default, it can be loaded with current timestamp
(ignore the field, or using DEFAULTIF)