Teradata Database Message 5882 - 5882 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
Invalid SET statement in the triggered action.
Explanation
(a) The SET statement syntax should be: SET <column-1> = <expression-1>; Where <column-1>, <column-2> are columns of the Subject Table on which the BEFORE row trigger is defined and <expression-1>, <expression-2> are scalar expressions. The SET statement can only be specified in definition of a Trigger. If it is used else where, this error message is generated. (b) Any syntactic of semantic errors in the SET statement.
Generated By
RES, SYN modules.
For Whom
End user or Field Engineer or the concerned site support Representative
Notes
SET Statement can only be specified either in a CREATE TRIGGER or in a REPLACE TRIGGER statement.
Remedy
None.