Archives of the TeradataForum

Message Posted: Fri, 20 Sep 2002 @ 22:32:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I try to create and update data for teradata tables. Since it is test cases the volume is not a concern. I want to do that via an online method. No FastExport, MLOAD, BTEQ, etc.

Also Queryman does not allows direct update.

With SAS, I succeed to directly browse the data but I did not find a way to update them. (SAS 6.09)

The best solution up to now is to connect via ODBC MS ACCESS to TERADATA. It works well to browse and add new rows. However, the update does not work as soon as one of the columns carries Time information or Date/Time stamps.

Does anyone found a solution to this update problem.

Thanks,

Marc.

	<Prev	Next>		<<First	<Prev	Next>	Last>>