Following two examples shows each of the above scenario.
CREATE SET TABLE DBNAME.TABLE_NAME ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
………
………
………
)
UNIQUE PRIMARY INDEX (COLUMN1 ,COLUMN2);
CREATE MULTISET TABLE DBNAME.TABLE_NAME, NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
………
………
………
)
UNIQUE PRIMARY INDEX (COLUMN1 ,COLUMN2);
Popularity: 60% [?]
Our Random Articles
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
- How to Post on a Separate/New Page in WordPress
- Usage of Macro in Teradata
More Links




4 Comments
An example or two would be helpful.
Hi Spicetrader,
Thank you for your comment. We have added the code. Hope that helps.
Would like to know what ‘ NO FALLBACK, AFTER JOURNAL, AFTER JOURNAL’ mean.
I am a bit confused. If Multiset allows duplicates, then how is there unique index?
Popular Articles