Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2008 @ 22:00:29 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: 3816: The positional parameter list has too few values
 
From:   Michael Larkins

kishore

          > Replace MACRO DebugMacro(ProcedureName varchar(500),tableName varchar(500)
          > default NULL,Description1 varchar(1000) default NULL,value1
          > Decimal(10,2) default NULL)

You have a minimum of Procedurename, tablename, description1 and value1 as parameters.

          > EXEC debugMacro ('abcdef');   <- where are the other 3 parameter values?

Default is not going to cut it. If you want them to be NULL, you have to pass NULL to the macro.


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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: 27 Dec 2016