Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Jan 2007 @ 11:34:53 GMT


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


Subj:   Re: Calling a procedure in a select statement
 
From:   Victor Sokovin

  I would like to know whether it is possible to call a procedure in a select statement. My procedure takes three parameters and returns one parameter. My query in TD looks like this :  


I don't think you can use procedures in this way. If you are looking for counterparts of Oracle functions then consider User Defined Functions (UDF). They can be used in SQL but to write them takes much more effort than in Oracle.

If the UDF threshold is too high you could think of making your SP write their results into certain tables and then join your existing tables to those "SP result tables". Perhaps this might work in some cases.


Regards,

Victor



     
  <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