Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 21 Apr 2003 @ 16:59:02 GMT


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


Subj:   Re: How to implement the sequence concept in teradata
 
From:   Sivaji. GV

On Fri, 11 Apr 2003 11:55:43 -0400, Anomy Anom wrote:

  Teradata doesn't support Sequence concept. I think by using procedure we can implement. Is it right or wrong. If it is wrong how to implement the sequence concept in teradata.  



For all who is thinking of SEQUENCE kind of feature, here is some info: Teradata DBS(version >= V2R5.0) now supports a a new feature called "Identity Column Support"(IDC). IDC column attributes are mentioned during create table statement to a column.

Eg of a create table stmt with idc column:

CREATE SET TABLE MLD.t ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      x INTEGER GENERATED ALWAYS AS IDENTITY
           (START WITH 1000
            INCREMENT BY 10
            MINVALUE 0
            MAXVALUE 300000
            NO CYCLE),
      y INTEGER)
UNIQUE PRIMARY INDEX ( x );

Check: help 'data_type attributes' for syntax of 'generated' attribute.


---
Sivaji.
---



     
  <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