All Forums Analytics
18 Oct 2012
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?

Qaisar Kiani 337 posts Joined 11/05
18 Oct 2012

You can do that for macros. See this link
http://forums.teradata.com/forum/database/macro-default-value-0
 

You must sign in to leave a comment.