Archives of the TeradataForum
Message Posted: Fri, 04 Apr 2008 @ 21:58:40 GMT
| Subj: || || Re: Identity -- min, max significance |
| From: || || Victor Sokovin |
| ||In my test cases , I've been able to insert the records to its limit but the same when done form Java/ JDBC there is a random failure
saying "exceeded identity limit " even though there were hardly few records present in the table.|| |
| ||Have checked the INS statement generated from java / JDBC, looks like, INS project (all columns except identity) values (.....);|| |
You might have hit the difference first communicated by Dieter in
In general, I would not recommend using identity column if you have a very precise set of rules you want the column to comply with. Identity
columns were designed to simply generate unique numbers. The numbers are never guaranteed to be sequential.
There many other approaches such as using functions like CSUM.