Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016