can't understand why my old sripts didn't work. Problem in MOD operator.
SELECT MOD(20,2)
Error: Query failed. 3706: Syntax error ...
Can't understand why MOD operator doesnt work any more.
Teradata SQL Assistent 15.10
Asked
Active
Viewed 2,545 times
0
-
Show us a complete query that fails. (As minimal as possible.) – jarlh Aug 08 '18 at 12:18
-
for example: SELECT MOD(-25,7) can be problem in 15 version? before i had 13 or 14 – Andrejs Aleksejevs Aug 08 '18 at 12:20
1 Answers
3
MOD(-25,7) is/was ODBC syntax which was (sometimes) automatically translated by the ODBC driver. Newer ODBC versions don't support it anymore (it was deprecated years ago). You either connect now using .NET or a newer ODBC driver.
The correct Teradata syntax is -25 MOD 7.
dnoeth
- 59,503
- 4
- 39
- 56