Execute code of procedure

Can you provide a code sample that fails? I'm not an expert in DB2 procedures, but I tried the following dummy code, and it executes successfully (I tried it in console):

create function dummy_function() returns integer language sql
begin
  declare v1 int default 10;
  set v1 = v1 + 2;
  return v1;
end;
select dummy_function() from dummy_table;

Regards,
Alexander.

For example:

CREATE OR REPLACE PROCEDURE TEST.name()
LANGUAGE SQL
BEGIN
   DECLARE v_perem1 INTEGER;
   SET v_perem1 = 2;
   DECLARE GLOBAL TEMPORARY TABLE tt_tab1
   (
      col1 INTEGER, 
      col2 INTEGER
   )  on commit preserve rows not logged with replace;
   begin
      DECLARE SWV_cursor_var CURSOR WITH RETURN FOR select SESSION.tt_tab1.col1, SESSION.tt_tab1.col2 FROM SESSION.tt_tab1 WHERE v_perem1 between col1  and col2;
      OPEN SWV_cursor_var;
   end;
END

Need  select the entire code and in the context menu select Execute Selection.
But in this case if there is an error in the code is difficult to determine exactly where it is.
Line number where is located error dosn not return.

Thank you. I've reproduce the problem and created the request: http://youtrack.jetbrains.com/issue/DBE-838

Without "WITH REPLACE" clause the code is executed normally on my side. (It's just a diagnostic, not a suggestion to remove the clause.)

However, if you meet other issues, welcome to report them too.

Regards,
Alexander.