Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Nov 2005 @ 19:48:44 GMT


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


Subj:   Re: Stored procedures results
 
From:   Eric Friedman

I'm a relative newcomer to Teradata (5 months), having done Oracle architecture design and development for several years. I wrote a highly flexible and efficient table-driven Oracle9/10 reporting application based on over 100 stored procedures that code-generate dynamic SQL, interfacing with a MS ASP ADO-based web front end that also generates dynamic SQL to populate its dropdown lists and display report results (since you never know ahead of time where the user will want to go).

From this discussion thread, it appears that there's no practical way to port such an application to Teradata at this time. What a shame! At least with BTEQ there's a serious kludge that allows you to retrieve dynamic SQL results by using BTEQ export to write them to a local Unix file, then using Unix utilities such as awk to parse the results and read them into Unix script environment variables. This allows your script to make branching decisions (although not within the BTEQ session) and quasi-generate dynamic SQL.

Unfortunately, it appears that both BTEQ and SP have a long way to go before they catch up to the competition.


Eric Friedman



     
  <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: 15 Jun 2023