Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: Greater and Least Function equivalent in DB2

    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.

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    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
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •