MVSFORUMS.com

[salimo]

Can someone offer some help with the below SQL
executing with "SPUFI" ,- "CASE" statements.
I've lookked at the SQL programmers guide, and cannot see
why the SQL below does not work?

SELECT NAME
CASE SEX_IND
WHEN = 'M' THEN 'MALE'
WHEN = 'F' THEN 'FEMALE'
ELSE 'UNKNOWN'
END AS GENDER
FROM EMP_TABLE;
--
-- aslo

--
SELECT SSN
CASE YEAR(CURRENT DATE - ADD_DT)
WHEN < 1 THEN '1 WEEK'
WHEN BETWEEN 1 AND 10 THEN '2 WEEKS'
WHEN BETWEEN 11 AND 20 THEN '3 WEEKS'
WHEN > 20 THEN '4 WEEKS'
ELSE 'UNKNOWN'
END AS VACATION
FROM EMP_TABLE;
Thank you.

[sriramla]

What is the sql error you get?
Error may be because there is no comma after first field( NAME or SSN).

[kolusu]

Salimo,

[salimo]

THANK YOU.
I was missing a comma after the column name on Select line.
AND
If your using a Date register the WHEN should refer to an interger, -
no ticks.
Thanks again for the reply.