All Forums Database
tommyromo 1 post Joined 10/14
12 Oct 2014
Greatest() function error in TD15

First time poster; database USER, not administrator/programmer, so I am not nearly as much of an expert as the rest of you.  However, I need help desperately.
I have Teradata 15, and was hoping to execute the greatest() function to return the maximum value across multiple columns.  Unfortunately, even when I enter something simple like...
select greatest(1,2)
...I get the error "SELECT Failed.  [3706] Syntax error: expected something between '(' and the integer '1'."
I have done a LOT of searching online and cannot find a solution to this problem.  Some of the information points to something called a "Database Initialization Program (DIP)", but I don't know what that is.  The Teradata guide says that I can run it through the "Database Window", but that was not included in my installation and cannot find the place to download it.
Any help would be greatly appreciated.


Raja_KT 1246 posts Joined 07/09
12 Oct 2014

I tried it works fine:
select TD_SYSFNLIB.greatest(1,4,5);

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.