Set Declared Variables...

[kizmar]

I'm a SQL Server (T-SQL) developer. I'm used to being able to declare a variable in a stored procedure, and set it using either SET or SELECT.

T-SQL:
DECLARE @variable INT

SET @variable = 10

How do I do the equivalent in DB2 SQL? I've tried about every combination I can think of.

My stored procedure stub:
CREATE PROCEDURE DB.PINVENTORY_TOTALS (
IN VAR_DATE DATE )

DYNAMIC RESULT SETS 1
LANGUAGE SQL
SPECIFIC DB.PINVENTORY_TOTALS
NOT DETERMINISTIC
MODIFIES SQL DATA
CALLED ON NULL INPUT

BEGIN

DECLARE VAR_YEAR INTEGER ;
DECLARE VAR_PERIOD INTEGER ;

DECLARE C_RETURN CURSOR WITH RETURN FOR

SET VAR_YEAR = (SELECT YEAR FROM CALENDAR WHERE VAR_DATE = CALDATE) ;

<Select statement here>

-- Get the result set
OPEN C_RETURN ;

END ;