Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 18 May 2009 @ 09:29:38 GMT


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


Subj:   Local Variables in Macro
 
From:   Padarthi, Hanumath

Hi,

I am using Macro to write some complex data manipulation. I need local variable in Macro to store intermediate values. Can any one give me syntax. I am getting error when I use Procedure syntax.

     Declare localvarb char(10);

2. Can we able to use select statement inside between like below

     Select * from testdb.emp
        where deptno between (select max(deptno) from testdb.dept) and 10

It throws below error.

     3706: Syntax error: expected something between '(' and Select keyword.

Regards,

Kumar.



     
  <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