OBJECT SET SYNC WHERE CLAUSE Command | unityadmin | Teradata Unity - OBJECT SET SYNC WHERE CLAUSE - 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

Sets the sync WHERE clause for a table.

Syntax

OBJECT SET SYNC WHERE CLAUSE {<objectname>} [ '<whereclause >]';

Parameters

objectname
Fully qualified name of the target object.
whereclause
WHERE clause to be used with the table sync SQL.

Example

unityadmin> OBJECT SET SYNC WHERE CLAUSE db0.t0 "WHERE c0 > 1";
The sync WHERE clause for table 'db0.t0' has successfully been set to: 'WHERE c0 > 1'.