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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DECODE in DB2
- Thread starter smita123
- Start date
Hai,
We have CASE expression in DB2 as workaround for DECODE Function in Oracle.
Eg.
Select DECODE(Name, 'XXX','My Name','Your Name') from TableName;
Select CASE NAME WHEN 'XXX' THEN 'My Name' ELSE 'Your Name' END from TableName
I hope,The above eg. will help you
We have CASE expression in DB2 as workaround for DECODE Function in Oracle.
Eg.
Select DECODE(Name, 'XXX','My Name','Your Name') from TableName;
Select CASE NAME WHEN 'XXX' THEN 'My Name' ELSE 'Your Name' END from TableName
I hope,The above eg. will help you
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question