Re: sql error

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Wed, 23 Jan 2002 12:59:02 +0000
Message-ID: <3C4EB396.5C8CB8F0@exesolutions.com>

I can see lots of things that are wrong.

What makes you think that DB2 syntax should work in Oracle?

RTFM Daniel Morgan

Gary Turner wrote:

> 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 - 06:59:02 CST