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?
Go to Solution.
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.