Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 03 Apr 2002 @ 07:59:17 GMT


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


Subj:   Re: Macros and parms
 
From:   Dieter Nöth

Hi Karen,

  I have written several macros that require input parms. The developers that are using these macros want to be able to use a column value from a table as one of the input parm values to these macros. Another wants to use the rowcount of a table as an input parm to these macros.  


  Just sql which will probably run in batch bteq.  



If it's a batch, following should work:

.export data file = myparams;
select the data you need;
export reset
import data file = myparams;
using col1 (datatype)
exec mymacro(:col1);


don't forget to delete myparams-file before the export / after the import, because Bteq appends to an existing file


Dieter



     
  <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