Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 10 Jan 2003 @ 14:28:29 GMT

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

Subj:   Re: VB for Applications to SQL Converer
From:   Anomy Anom

<-- Anonymously Posted: Friday, January 10, 2003 09:21 -->


I do not suspect that such a tool exists. The difficulty in creating such a tool is that SQL is generally a set-based operation against the data in the table. Through mechanisms such as DAO and ADO Visual Basic can submit SQL to retrieve a resultset and then process the data row by row (read: iterative). Without seeing or fully understanding any of the code in question, my assumption is that you will need to evaluate each VB function, procedure and Access stored/SQL Pass-through query manually and convert it to Teradata Macros or batch jobs that can be run nightly.

One other thing to consider is that the code is run asynchronously vs. the default of synchronously. This will help you deploy analytical reports via web pages that generally take longer than a minute to run without severly impacting your web server's performance. We are faced with similar challenges regarding web applications being written with the expectation of near-real time response.

I hope this helps and maybe sparks some good conversation regarding these topics. Feel free to share as much information as you can, it will help determine the best route you should take.

  <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: 28 Jun 2020