Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.

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

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020