IBM Mainframe Forum

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 ?

Hello,

Try CURRENT_TIMESTAMP.