Teradata Database Message 9718 - 9718 - 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
- %VSTR function is nondeterministic. Cannot be used in WHERE or SET clause.
- Explanation
- The user included a nondeterminisitc UDF or the RANDOM function in an UPDATE or DELETE query. Nondeterministic UDFs and the RANDOM function are not supported in either WHERE clauses or SET clauses of UPDATE or DELETE DMLs.
- Generated By
- OPT modules.
- For Whom
- End User.
- Notes
- None
- Remedy
- Correct the expression and re-submit the query.