Archives of the TeradataForum
Message Posted: Mon, 25 Feb 2008 @ 21:22:58 GMT
| Subj: | | Re: 3816: The positional parameter list has too few values |
| |
| From: | | McCall, Glenn David |
| | Can any one tell me why I am getting error at macro execution? | |
You should read the manual. Specifically the "SQL Reference - Data manipulation manual". More precisely the section titled "Execute (macro
form)".
In it, you will find two methods for execing a macro.
1) positional parameter list - all parameters must be accounted for by commas e.g. exec p4 ( , 'hello', 'there', ); is a 4 parameter
macro with the first and last parameters omitted (they will be null in the macro)
2) named parameter list - parameters may be named. Omitted parameters are null. E.g. exec p4 (p3 = 'there', p2 = 'hello'); would be
the same as the previous example assuming the parameters are labelled p1, p2, p3 & p4.
| | In macro I want pass only Procedurename the remaining parameter need as optional. | |
The manual lists the rules and this isn't one of them.
| 
