DB2 Version 9.7 for Linux, UNIX, and Windows

Variable related statements in SQL procedures

Variable related SQL statements are used to declare variables and to assign values to variables. There are a few types of variable related statements:

DECLARE <variable> statement in SQL procedures
DECLARE <condition> statement in SQL procedures
DECLARE <condition handler> statement in SQL procedures
DECLARE CURSOR in SQL procedures
SET (assignment-statement) in SQL procedures

These statements provide the necessary support required to make use of the other types of SQL PL statements and SQL statements that will make use of variable values.