Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 15 Dec 2008 @ 22:57:01 GMT


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


Subj:   Re: What is the alternative way to sequence
 
From:   Saxena, Rakesh

Hi,

If your requirement is to generate the sequence number alone then you can add an additional column called as "Sequence_no" as part of the table and declare as mentioned below.

     Sequence_no integer generated always as identity,

This will create a unique number for each record that gets inserted into your table. No need to add this column as part of the SQL (Insert and select clause) used in the procedure. This will automatically generate a unique number.


Regards,

Rakesh Saxena.



     
  <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: 15 Jun 2023