17.10 - Example: Setting an Alternate Constraint Value - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

You can provide an alternate constraint value in the SQL statement. For example:

MERGE INTO table1 AS tgt USING table2 AS src
   ON (tgt.col1 = src.col1) WHEN MATCHED THEN UPDATE SET Level = 2;

where SET Level = 2 sets the security constraint column “Level” to a value of 2 for all updated rows.

You can alternately specify:

  • That a value is taken from another column. For example:
    SET Level = src.column_name ;
  • Values for multiple constraint columns. For example:
    SET Level = 2, Class = 4, Job = 7, ... ;