The DECODE scalar function in DB2 SQL helps you handle logic related scenarios. You can also handle NULL values and you can replace NULL values with values as you wish in your end result.