Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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.


     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??


Anomy Anom

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023