SQL PL statements

From SQL PL Guide for DB2

Supported SQL/PL statements

The following SQL/PL statements are supported in DB2:

• Variable related statements
  • DECLARE <variable>
  • DECLARE <condition>
  • DECLARE <condition handler>
  • DECLARE CURSOR
  • SET
• Conditional statements
  • CASE
  • IF
• Looping statements
  • FOR
  • LOOP
  • REPEAT
  • WHILE
• Transfer of control statements
  • CALL
  • GOTO
  • ITERATE
  • LEAVE
  • RETURN
• Error management statements
  • SIGNAL
  • RESIGNAL
• Result set manipulation statements
  • ASSOCIATE LOCATOR
  • ALLOCATE CURSOR

Infocenter: DB2 9DB2 9.5DB2 9.7