Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Actuate 8 (DB2 - CASE statement problem)?
Found solution ... :) CASE WHEN :PARAMETER = 'N' THEN 'CODE 1' WHEN :PARAMETER = 'P' THEN 'CODE 2' WHEN :PARAMETER = 'R' THEN 'CODE 3' END thank you anyway- 5432167
- Post #2
- Forum: Actuate Reporting Solutions
-
Actuate 8 (DB2 - CASE statement problem)?
Hello, i'm having a problem with CASE statement... How can i use PARAMETER inside CASE? Example(DB2): SELECT ( CASE :PARAMETER 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
- Thread
- Replies: 1
- Forum: Actuate Reporting Solutions
