 |
 |
Archives of the TeradataForum
Message Posted: Tue, 08 Apr 2014 @ 15:31:32 GMT
| Subj: | | Re: Problem with IDENTITY Column |
| |
| From: | | Dieter Noeth |
David Clough wrote:
| | "When you do single-row inserts, the PE will fetch and increment the IdCol value as specified in the definition. " | |
Replace "the PE" with "each PE" :-)
| | All I can say is that these (test) rows were added yesterday, and today it's not working ! | |
Your session logged on through another PE which requested the next bunch of 100.000 ids.
Each AMP/PE maintains it's own sequence.
| | It's a pity, as it was ideal for what I was doing. | |
What *are* you doing? Maybe there's a better workaround.
Dieter
| |
