>>-+--------+--CASE--+-simple-when-clause---+-------------------> '-label:-' '-searched-when-clause-' >--+-------------+--END CASE----------------------------------->< '-else-clause-' simple-when-clause: |--expression---------------------------------------------------> .---------------------------------------------------------. | .-----------------------------. | V V | | >----WHEN--expression--THEN----SQL-procedure-statement-- ;-+-+--| searched-when-clause: .---------------------------------------------------------------. | .-----------------------------. | V V | | |----WHEN--search-condition--THEN----SQL-procedure-statement-- ;-+-+--| else-clause: .-----------------------------. V | |--ELSE----SQL-procedure-statement-- ;-+------------------------|
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.