Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 25 Feb 2008 @ 21:22:58 GMT

  <Prev Next>   <<First <Prev

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.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019