Archives of the TeradataForum

Message Posted: Wed, 05 May 2004 @ 20:08:57 GMT

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

The use of RowID has been disabled in V2R5 going forward. V2R5.0 offers a GDO flag which can be set to enable RowID, but this flag is not enabled by default. V2R5.1 does not offer this backwards compatibility flag, ie. no use of RowID allowed.

Without using RowID, one way to delete complete row duplicates in a multiset table is to insert-select into a new table, picking a winning row amongst duplicates using a RANK or CSUM function. Alternatively, you could insert-select into a set table (thereby eliminating duplicates). In either case, you would have to then delete your multiset table, and insert-select from your "non-duplicate" table back into your multiset table.

Donald Maxwell

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