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

Product
Teradata Business Continuity Manager
Release Number
1.0
Published
January 2022
Language
English (United States)
Last Update
2022-01-27
dita:mapPath
otc1639627713801.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'.