Archives of the TeradataForum

Message Posted: Wed, 06 Oct 2010 @ 14:39:16 GMT

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

Hi,

Currently we are migrating SQL Server procedure to Teradata , We have procedures in SQL Server which have mandatory parameter as well as parameters with default value.

These procedures are repeatedly called in our application, sometimes input will be passed for default parameters and sometimes not.

Could anyone help us to create a procedure with default parameter list, while calling these procedures the parameter should take the default value instead of explicitly providing the parameter.

Any workaround is also welcome.

Changing the application code to input all parameters is out of scope.

Regards

Asish Murali.M

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