sequence 1

[DFW1999]

Can somebody tell me how to insert a sequence in teradata table.
I tried to use csum() for this insert. It did not work.
CSUM() I can use when selecting data from an other table. But in this case I am inserting new rows in a table and want to add a unique seq no each time a row inserts into this table.

thanks

 

[dnoeth]

Use V2R5, there's a sequence now ;-)

Can you supply more info how you're trying to insert ?

Is it a batch load (fastload/multiload)?
- Write an Inmod, this is the only way to have a sequence# according to the order of records in your input file
- Load into a stage table, then insert/select using CSUM

Or do you insert using SQL?
Insert/select?
- CSUM

Single row inserts?
- There is no scalable solution, insert will always run serially

Dieter