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


  <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: 28 Jun 2020