Archives of the TeradataForum

Message Posted: Fri, 10 Jan 2003 @ 14:44:16 GMT

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

As Anomy said, SQL is set-based, and most application are design to operate in a serial row-at-a-time manner. This means that you really don't want to run a converter to just change the code to run as SQL you need to rethink the logic and redesign the application to run as set logic. I have come across many similar situations at other customers sites. Even porting applications from Oracle in many cases we see the row-at-a-time logic using cursors. This generally is not very efficient in any Relation DB and especially in Teradata.

I know this is not the answer you wanted, however the good news is, in many cases the SQL to run these applications with set logic is much more simple than the original applications.

Edmond Ray
Senior Data Warehouse Consultant
Special Programs, NCR Government Systems

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