CREATE PROCEDURE BA_TST ()
language sql
dynamic result sets 1
begin
  declare c1 cursor with return for 
    select g.raion, m.regnum
    from grafik g
    join masterregnum m on g.id_regnum=m.id_regnum
    where g.raion='003';
  open c1;
end@

for g as
  select raion, id_regnum 
  from grafik 
  where raion='003'
do
  select regnum into p3
  from masterregnum
  where id_regnum=g.id_regnum;
end for;

for g as
  select raion, id_regnum 
  from grafik 
  where raion='003'
do
  set p3=
  (
  select regnum
  from masterregnum
  where id_regnum=g.id_regnum
  );
end for;

CREATE PROCEDURE BA_TST(OUT P3 VARCHAR( 15 ))

>>-DECLARE GLOBAL TEMPORARY TABLE--table-name------------------->

        .-,---------------------.
        V                       |
>--+-(----| column-definition |-+--)-----------------------------+-->
   +-LIKE--+-table-name1-+--+------------------+-----------------+
   |       '-view-name---'  '-| copy-options |-'                 |
   '-AS--(--fullselect--)--DEFINITION ONLY--+------------------+-'
                                            '-| copy-options |-'

      .-ON COMMIT DELETE ROWS---.
>--*--+-------------------------+--*---------------------------->
      '-ON COMMIT PRESERVE ROWS-'

>--+-------------------------------------------+---------------->
   |             .-ON ROLLBACK DELETE ROWS---. |
   '-NOT LOGGED--+---------------------------+-'
                 '-ON ROLLBACK PRESERVE ROWS---'

>--*--+--------------+--*--+---------------------+-------------->
      '-WITH REPLACE-'     '-IN--tablespace-name-'

column-definition:

|--column-name--| data-type |--+--------------------+-----------|
                               '-| column-options |-'

column-options:

|--*--+----------+--*--+----------------------------------------------------------------------+--*--|
      '-NOT NULL-'     +-| default-clause |---------------------------------------------------+
                       '-GENERATED--+-ALWAYS-----+--AS--IDENTITY--+-------------------------+-'
                                    '-BY DEFAULT-'                '-| identity-attributes |-'

copy-options:

                                                                        .-COLUMN ATTRIBUTES-.
                                                  .-EXCLUDING IDENTITY--+-------------------+-.
|--*--+-------------------------------------+--*--+-------------------------------------------+--*--|
      |                .-COLUMN-.           |     |                     .-COLUMN ATTRIBUTES-. |
      '-+-INCLUDING-+--+--------+--DEFAULTS-'     '-INCLUDING IDENTITY--+-------------------+-'
        '-EXCLUDING-'