Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Jul 2005 @ 22:00:59 GMT


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


Subj:   Execute a macro with multiple criteria
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, July 08, 2005 17:55 -->

I'm wondering if it is possible to execute a macro with multiple criteria for a variable.

Example:

     replace macro my_macro( variable integer) as(
     sel * from table1 where field in :variable;
     );

     execute my_macro( (1,2,3) );

I'm trying to execute with multiple variables similar to above; however, I'm getting a syntax error. Is this possible??


Thanks,

Anomy Anom



     
  <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: 27 Dec 2016