Greater and Least Function equivalent in DB2

jdrcsdrc · #1 (**permalink**) 05-31-06, 18:54

I want to convert the following Oracle SQL into DB2 SQL I am having issues dealing with the Grater and Least Functions:

Code:

CASE WHEN integrated  = 0 THEN 
       CASE WHEN centered = 0 THEN
             GREATEST(tl.timelabel - (1/24),STARTTIME)
            WHEN centered <> 0 THEN
              GREATEST(tl.timelabel - (1/24),mwseg.starttime + 0.5 * (mwseg.stopTime-(mwseg.rampdown/(24*60)) - STARTTIME ) )
       END
 END StartHour

Any help appreciated, I already did a quick search with no luck, sorry if it is a repeat post.

Thanx in advance.

Wim · #2 (**permalink**) 06-01-06, 02:43

I had the same problem, perhaps there is a better solution, but I used an extra CASE statement

Code:

CASE WHEN integrated  = 0 THEN 
       CASE WHEN centered = 0 THEN
             CASE WHEN tl.timelabel - (1/24) > STARTTIME
                    THEN tl.timelabel - (1/24)
                    ELSE STARTTIME
             END
            WHEN centered <> 0 THEN
              ....
       END
 END StartHour

Internet Services

Web Development

Digital Marketing

Consumer Tech