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

Teradata® Business Continuity Manager User Guide - 1.01.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
1.01.01
Published
March 2023
Language
English (United States)
Last Update
2023-03-13
dita:mapPath
qra1653979755546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Sets the validation WHERE clause for a table.

Syntax

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

Parameters

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

Example

bcmadmin> OBJECT SET VALIDATION WHERE CLAUSE db0.t0 "WHERE c0 > 1";
The validation WHERE clause for table 'db0.t0' has successfully been set to: 'WHERE c0 > 1'.