OBJECT SET DETERMINISM Command | unityadmin | Teradata Unity - OBJECT SET DETERMINISM - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

Purpose

Set the override level for the determinism of an object.

Syntax

OBJECT SET DETERMINISM <object_name> [NO OVERRIDE | FORCE DETERMINISTIC | FORCE NONDETERMINISTIC]

Parameters

FORCE DETERMINISTIC
Treats an object as deterministic
FORCE NONDETERMINISTIC
Treats an object as nondeterministic
NO OVERRIDE
Allows Unity to decide the object determinism
objectname
Fully qualified name of the target object

Example

At the unityadmin prompt:

Input Result
OBJECT SET DETERMINISM databasename.objectname FORCE NONDETERMINISTIC; Forces Unity to use CDM replication for SQL statements which
  • Perform a write; and
  • Reference the named object
OBJECT SET DETERMINISM databasename.objectname FORCE DETERMINISTIC; Forces Unity to not use CDM replication due to the named object being referenced in the SQL statement. This does not guarantee that the SQL statement will not result in CDM replication due to the determinism level of other objects referenced within the same SQL statement.
OBJECT SET DETERMINISM databasename.objectname NO OVERRIDE; Allows Unity to decide which replication type to use in regards to the named object being referenced within a SQL statement.