Archives of the TeradataForum
Message Posted: Thu, 18 Aug 2005 @ 08:07:25 GMT
I want to use IDCs in some tables. I use the sysntax like
[...] TABLE_ID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 NO CYCLE) ,TABLE_ORDER INTEGER NOT NULL [...]
I wonder about the cache for the generated numbers. I miss the option 'no cache'. I have the sometimes steps like:
TABLE_ID 1 2 3 4 10001 10002 30001 ...
Normally that's no problem, but in some scripts (for testing) I had the foreign-key numbers fixes in an insert statement. Is there any possibility to disable the caching of numbers?
Thanks in advance,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|