Archives of the TeradataForum

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

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

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>>