Archives of the TeradataForum

Message Posted: Sun, 20 Jan 2002 @ 12:18:52 GMT

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

Craig,

I don't think there's an option at the database level. The SET or MULTISET option is really based on the session that issues the create table statement. On that side you can set the default to be either ANSI or Teradata.

If the session which issues the create table is running in ANSI mode, then the default is to create a multiset table, whereas if the session is running in Teradata mode then the default is to create a set table. Note that these are only defaults and can be over-ridden on the create table statement.

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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