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.
---