Any of the following statements:
o DECLARE ALIAS
o DECLARE CURSOR
o DECLARE STATEMENT
o DECLARE TABLE
o DECLARE TRANSACTION
You must place all DECLARE statements in an SQL module together
after the LANGUAGE clause of the module. All such DECLARE
statements are optional.
All the DECLARE statements except DECLARE TRANSACTION can be
repeated. For each DECLARE CURSOR statement, however, there must
be only one procedure in the SQL module that contains an OPEN
statement that corresponds to the DECLARE CURSOR statement.
Do not use any punctuation to separate DECLARE statements or
to separate the declare-statement section from the procedure
section.