sql error

From: Gary Turner <gary.turner_at_sanmina-sci.com>
Date: Wed, 23 Jan 2002 14:16:12 -0600
Message-ID: <iNE38.23656$h31.2260953@e420r-atl1.usenetserver.com>

does anyone see what is wrong with this sql statement?? i keep getting a missing expression error and i can't seem to find anything that seems wrong.

UPDATE SFPO SET
  RELEASE_DT = CASE WHEN SUBSTR(RELEASE_DT_WRK,1,1) > '4'

    THEN DATE('19' CONCAT SUBSTR(RELEASE_DT_WRK,1,2)
        CONCAT '-' CONCAT SUBSTR(RELEASE_DT_WRK,4,2)
        CONCAT '-' CONCAT SUBSTR(RELEASE_DT_WRK,7,2)

  ELSE
    DATE('20' CONCAT SUBSTR(RELEASE_DT_WRK,1,2)     CONCAT '-' CONCAT SUBSTR(RELEASE_DT_WRK,4,2)     CONCAT '-' CONCAT SUBSTR(RELEASE_DT_WRK,7,2))   END; we have this same sql running daily on DB2, but there shouldn't be any difference. Received on Wed Jan 23 2002 - 14:16:12 CST