OBJECT SET SYNC WHERE CLAUSE Command | Teradata Business Continuity Manager - OBJECT SET SYNC WHERE CLAUSE - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 2.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
2.00
Published
August 2024
ft:locale
en-US
ft:lastEdition
2025-01-31
dita:mapPath
sko1694443904278.ditamap
dita:ditavalPath
ft:empty
dita:id
otc1639627713801
lifecycle
latest
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

bcmadmin> 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'.