Archives of the TeradataForum
Message Posted: Fri, 10 Jan 2003 @ 14:44:16 GMT
| Subj: || || Re: VB for Applications to SQL Converer |
| From: || || Ray, Edmond |
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.
Senior Data Warehouse Consultant
Special Programs, NCR Government Systems