Passing parameter in macro/procedure

Analytics

Passing parameter in macro/procedure

Hi,

Is there any option available in Teradata to set a default value, while initializing a parameterised variable?

Example:

In Oracle, we have like

Create or replace procedure sample (firstname varchar(20) DEFAULT NULL, lastname varchar(20) DEFAULT NULL)

as 

BEGIN

--- statement block

END sample;

If we does not pass value to variable lastname, it will automatically consider NULL as Default value and pass it into procedure. So, there is NO compulsory to pass value.

Is there any option present in Teradata?

1 REPLY
Enthusiast

Re: Passing parameter in macro/procedure

You can do that for macros. See this link

http://forums.teradata.com/forum/database/macro-default-value-0