Archives of the TeradataForum
Message Posted: Sun, 20 Jan 2002 @ 12:18:52 GMT
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.
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved
|Last Modified: 15 Jun 2023