Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 20 May 2004 @ 15:50:50 GMT

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

Subj:   Re: Stored Procedure vs. Macro
From:   Ballinger, Carrie

The only point I'd add to those already mentioned is that it's easier to return multi-row answer sets in a macro, such as you might do if you have several rows with the same NUPI value that qualify from PI access. With a stored procedure you might have to insert each NUPI row into a temp table, then access that temp table after the SP completes...or you could use IF THEN...ELSE and cursor logic in the SP to loop through the NUPI rows.

For simple stuff and multi-row answer sets, macros offer an advantage both in performance and ease of use.

Thanks, --Carrie

  <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: 23 Jun 2019