Archives of the TeradataForum

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

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

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