Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Dec 2008 @ 13:35:18 GMT


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


Subj:   What is the alternative way to sequence
 
From:   Sridhar Nakka

Hi Guys,

We are migrating our database from oracle to teradata. In procedures we are using the sequences to generate the next values.

We are invoking this in procedures using statement

     select S4028_GROUPS.NEXTVAL into v_NewGroupId from dual

as of I know teradata will not support sequences. So how can we rectify this problem in teradata?

Please help me..


Regards

Sridhar Nakka



     
  <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