Archives of the TeradataForum

Message Posted: Tue, 21 Sep 2004 @ 20:00:13 GMT

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

From: Dempsey, Mike

We've been doing research:

- Teradata SQL Assistant, Teradata Administrator and MS Excel are limited to DECIMAL(15).

- ODBC is limited (per standard) to DECIMAL(15), which of course constrains products that use it.

- CLIv2 has no described limit, but I expect that it's DECIMAL(18) to support the system.

- Everything else (MS Access, OLEDB, JDBC, Visual Basic) has a limit of DECIMAL(28).

So I guess that means we need to ask Mike when Teradata is going to convert the NCR desktop products from ODBC to OLEDB... ;)

/dave hough

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