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, ... ;