Archives of the TeradataForum

Message Posted: Wed, 25 Aug 2004 @ 16:59:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Rajah and All,

I know this is not exactly related to the question posed but it may help some people avoid the problems that I ran into one time.

If you are using the "CREATE TABLE XXX AS YYY...." statement, the table will default to be a set table. You need to explicitly define the new table to be Multiset even if the target table is already Multiset.

For example, if the table you are copying is multiset and you want your new table to be multiset as well, you must use the statement "CREATE MULTISET TABLE XXX AS YYY...." otherwise it defaults to a set table.

Mark K. Ferguson
Teradata Certified Master
CDW/Accenture USAF - FIRST Project

	<Prev	Next>		<<First	<Prev	Next>	Last>>