I'm trying to import a pipe delimited flatfile using the import functionality of the Teradata SQL Assistant through following SQL statement
insert into S0_SDB_COP.VVA_00213_S_ITM_CALLBACK (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
The 2 timestamps are mentioned in the flatfile as follow (17th and 18th column):
|30/03/2010 14:11:08|30/03/2010 14:11:08|
My table has 2 timestamp fields defined as:
, DT_START TIMESTAMP (0) FORMAT 'DD/MM/YYYYBHH:MI:SS'
, DT_END TIMESTAMP (0) FORMAT 'DD/MM/YYYYBHH:MI:SS'
I dont see anything wrong with the format in the flatfile. I also double checked the position of the columns in the flatfile to be sure they match the position of the column in the table.
I tried both ODBC and ADO.net connectivity in the SQL Teradata Assistant.
Still the same error....
Can anyone help?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.