Actuate 8 (DB2 - CASE statement problem)?

[5432167]

Hello,

i'm having a problem with CASE statement...

How can i use PARAMETER inside CASE?

Example(DB2):

SELECT ( CASE ARAMETER
WHEN 'N' THEN 'CODE 1'
WHEN 'P' THEN 'CODE 2'
WHEN 'R' THEN 'CODE 3'END) As Vsota,
...
...
FROM
...
...
WHERE
...
...


hope that u can help me ...

 

[5432167]

Found solution ...


CASE WHEN ARAMETER = 'N' THEN 'CODE 1'
WHEN ARAMETER = 'P' THEN 'CODE 2'
WHEN ARAMETER = 'R' THEN 'CODE 3' END


thank you anyway