IBM Mainframe Forum

Hi,

I would like to populate a field with a word depending on another column (e.g. use 'First' when field=1, use 'Second' when field =2).

The below 'CASE' usage works for TSQL, but doesn't in mainframe. Any suggestions on an alternative ?

Thanks!


Select *,
'Status' = CASE
WHEN place = 1 THEN 'FIRST'
WHEN place = 2 THEN 'SECOND'
WHEN place = 3 THEN 'THIRDE'
ELSE 'No Medal'
END
FROM dbo.finals;

what language are you using, is it COBOL?

Try this:

open a manual and look up case

1) giving a expression a name is not via syntax "Status" = .... , it 's ... as "Status"
2) when selecting other "columns" beside * you need to qualify it .