 |
 |
Archives of the TeradataForum
Message Posted: Wed, 03 Apr 2002 @ 07:59:17 GMT
| 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
| |
