Teradata Database Message 4805 - 17.10 - 4805 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
%FSTR %VSTR
Explanation
1) One of the IN TABLE name or the value is repeated in another IN TABLE clause or in general NVP's. 2) ANY cannot be specified multiple times as value in IN TABLE clause 3) ANY cannot be specified as value when there is ANY IN TABLE clause
Generated By
RES modules.
For Whom
End User.
Notes
None
Remedy
1) Ensure not to use IN TABLE names or values in general NVP's or in other IN TABLEs. 2) Ensure not to use ANY multiple times as value in IN TABLE clause. 3) Ensure not to use ANY as a substitution value when there is atleast one ANY IN TABLE.