Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 20:18:40 GMT

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

As with most of Microsoft's 'high level' data access tools they are built to provide good functionality for SQL Server.

.Net probably has less functionality that any of the earlier tools. The one with the most functionality is the base ODBC API itself. ADO (pre .Net) also has missing functionality - and no way around it. RDO has missing functionality, but allows you to 'drop down' into the ODBC API if you need anything that is missing.

I therefore recommend that anyone building a new ODBC based app stick with RDO if they may need anything that is not 'Standard'. It may be old ... But it works.

(The API itself also works well ... But it is a lot of work, and requires close attention to detail/specs, if you go that route.)

Teradata is the only database that I know of that can tell you the number of rows in the answer set BEFORE it returns them. As a result this is basically 'non-standard' functionality.

Mike Dempsey
Teradata Client Tools

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