how to insert default timestamp value in fastload

Database
Enthusiast

how to insert default timestamp value in fastload

I want to insert default sever datetime into a column with timestamp(6) datatype via Fastload. I WONT create table in my script. Please help me with default syntax on how to define & insert this default value?

 

Thank You


Accepted Solutions
Teradata Employee

Re: how to insert default timestamp value in fastload

You first have to define the column in the table as having DEFAULT CURRENT_TIMESTAMP.

Then in the FastLoad specify the other column names and corresponding values in the INSERT, but omit the column you want defaulted.

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: how to insert default timestamp value in fastload

You first have to define the column in the table as having DEFAULT CURRENT_TIMESTAMP.

Then in the FastLoad specify the other column names and corresponding values in the INSERT, but omit the column you want defaulted.