Search results
10 mar 2010 · There are two forms of CASE: Simple WHEN clause and searched WHEN clause, and the syntax for either form is pretty straightforward. Here’s the syntax of the simple WHEN clause: CASE target-expression WHEN condition-1 THEN result-expression-1 WHEN condition-2 THEN result-expression-2 … WHEN condition-n THEN result-expression-n (at least one ...
The CASE statement selects an execution path based on multiple conditions. This statement should not be confused with the CASE expression, which allows an expression to be selected based on the evaluation of one or more conditions.
In general, the value of the case-expression is the value of the result-expression following the first (leftmost) case that evaluates to true. If no case evaluates to true and the ELSE keyword is present then the result is the value of the result-expression or NULL.
It contains reference information for the tasks of system administration, database administration, application programming, and operation. This manual includes syntax, usage notes, keywords, and examples for each of the SQL statements used on the system.
A CASE expression allows you to select an expression based on evaluation of one or more conditions. In other words, it allows you to add the if-else logic to your queries. Db2 supports two kinds of CASE expressions: simple CASE and searched CASE expressions.
DB2 - SQL Case Statement. The CASE statement goes through conditions and returns a value when the first condition is met (like an COBOL Evaluate statement). So, If a condition is true, it will stop reading and return the result. If no conditions are true, it returns the value in the ELSE clause.
The SQL CASE statement is a conditional statement. The CASE statement works like a simple IF-THEN-ELSE statement. It test multiple condition and return a value when the first condition is satisfied. CASE syntax. WHEN condition1 THEN result1. WHEN condition2 THEN result2. WHEN conditionN THEN resultN. ELSE result. END.
