Can we insert CURRENT TIMESTAMP using LOAD command



IBM's flagship relational database management system

Can we insert CURRENT TIMESTAMP using LOAD command

Postby karthickrajamani » Mon Nov 17, 2008 7:06 pm

HI,

i have a file which has some 10 fields. i need to load these into a table which has 11 fields, the 11th being the timestamp. My requirement is to load the CURRENT TIMESTAMP in the field in the table. Is this possible thru the LOAD utility. I tried giving CURRENT TIMESTAMP as Type for the field and Loading using LOAD command but it says "INVALID KEYWORD - CURRENT". Somebody throw some light on this or suggest a suitable alternative ?
karthickrajamani
 
Posts: 3
Joined: Tue Aug 19, 2008 3:52 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Can we insert CURRENT TIMESTAMP using LOAD command

 

Re: Can we insert CURRENT TIMESTAMP using LOAD command

Postby dick scherrer » Tue Nov 18, 2008 12:29 am

Hello,

Try CURRENT_TIMESTAMP.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post