How do you Generate Sequence in Teradata?

Answer Posted / kk

1-for storing purpose using identity

2-for display purpose using csum

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can we analyze the locks ?

1908


What does sleep function does in fast load?

873


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

886


What are some primary characteristics of teradata?

782


What is the purpose of upsert command?

843


What is smp and mpp platforms?

752


What are differences between teradata and ansi session modes in teradata?

908


What do you mean by ttu in teradata?

779


What tools would you use for that?

843


What does Amp contain and what are all the operations that it performs?

804


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

775


Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

953


Define views in teradata with syntax.

864


What is spool space?

850


When tpump is used instead of multiload?

879