Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Default parameter value in Stored procedure
 
From:   Asish Muralidas

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016