![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 14 Apr 2011 @ 12:41:19 GMT
Subj: | | Re: Comma in Macro Parameter |
|
From: | | de Wet, Johannes |
Craig - We've used the following 2 methods in the past:
1. Using a WITH RECURSIVE function inside the macro to break out the parameter into an in-list. The data would be need to be passed to the
macro in the following format: EXEC myMacro ('x,y,z');
2. Using the format EXEC myMacro ('x,y,z'); and then using a join to the SYS_CALENDAR table inside the macro to break out the parameter list
into an in-list.
Thanks.
Johannes de Wet
Unum
| |