SQL Statements › SQL Statements › CREATE PROCEDURE Statement › CASE Statement

CASE Statement

►►─ CASE ─┬─ proc-value-expression ─┤simple-when-stmt-list├─┬─────────────────►
          └┤searched-when-stmt-list├────────────────────────┘

 ►─┬────────────────────────────┬─ END CASE ──────────────────────────────────►◄
   └ ELSE ─┤proc-SQL-stmt-list├─┘

Expansion of simple-when-stmt-list

   ┌──────────────────────────────────────────────────────┐
├──▼─ WHEN proc-value-expression THEN proc-SQL-stmt-list ─┴────────────────────┤

Expansion of searched-when-stmt-list

   ┌──────────────────────────────────────────────────────┐
├──▼─ WHEN proc-search-condition THEN proc-SQL-stmt-list ─┴────────────────────┤

Expansion of proc-SQL-stmt-list

   ┌──────────────────┐
├──▼─ proc-SQL-stmt; ─┴────────────────────────────────────────────────────────┤

A proc-value-expression is a variant form of the expressions used to specify values.

Note: For information about expressions, see the CA Datacom/DB SQL User Guide

For proc-SQL-stmt syntax, see Proc-Body Syntax.