Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 14 Nov 2005 @ 14:44:17 GMT


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


Subj:   Re: Stored procedures results
 
From:   Glen Blood

Sorry to disagree

  "We have never needed SP in Teradata and the main reason they seem to be there now is because Oracle required them to do most anything productive."  



I use them extenisvely in my automated infrastructure. The ability to use dynamic SQL and DDL is invaluable. The way I usually use them is to create the SQL (sometimes using cursors) on the fly and running it dynamically. By doing it this way, you lose none of the Parallelism of Teradata.

I have created an automated space management system using Stored Procedures. I have also created Aggregation Routines for my applications. They are a vast improvement in the capabilities of the system.


Glen



     
  <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