how to create variable in sql procedure?

getting an error when I compile an SQL procedure. Error is on the CREATE
VARIABLE statement.
SQL0104 30 11 Position 9 Token VARIABLE was not valid. Valid
tokens: VIEW ALIAS TABLE SCHEMA.

but I can compile and run the same statement in an SQLRPGLE program.

why this error? How to create a variable in an SQL procedure? I am at
V7R2.

thanks,




1
2 CREATE or replace PROCEDURE
sql_test1(
3
)
4 LANGUAGE
SQL
5 MODIFIES SQL
DATA
6 SET OPTION DBGVIEW =
*SOURCE
7 BEGIN
atomic
8 declare vSqlCode decimal(5,0)
;
9 declare sqlCode int DEFAULT 0
;

10
11 CREATE VARIABLE qgpl.GV_DEPTNO char(20) default 'Unassigned'
;
12 SET GV_DEPTNO = 'ABC'
;

13
14
END
* * * * * E N D O F S O U R C E * * *
*
5770SS1 V7R2M0 140418 Run SQL Statements
REPZIOP5T
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
...+...
MSG ID SEV RECORD TEXT
SQL0104 30 10 Position 9 Token VARIABLE was not valid. Valid tokens:
VIEW ALIAS TABLE SCHEMA.