create procedure huge_upd(
  sel_stmt varchar( 1024 )
, upd_stmt varchar( 1024 )
, comm_cnt int)
begin
  declare SQLCODE int;
  declare v varchar( 1024 );
  declare i int default  1 ;

  declare c1 cursor with hold for s;
  prepare s from sel_stmt;
  set upd_stmt = upd_stmt || ' where current of c1';
  open c1;
  fetch c1 into v;
  while SQLCODE!= 100  do
    execute immediate upd_stmt;
    if i=comm_cnt then 
      commit;
      set i= 1 ;
    else 
      set i=i+ 1 ;
    end if;
    fetch c1 into v;
  end while;
  commit;
end@

call huge_upd(
  'SELECT REGION FROM DB2ADMIN.BAZA05A WHERE REGION IS NULL for update of REGION'
, 'update DB2ADMIN.BAZA05A set REGION=''''',  1000 )@
...
call huge_upd(
  'SELECT S_ULICA FROM DB2ADMIN.BAZA05A WHERE S_ULICA IS NULL for update of S_ULICA'
, 'update DB2ADMIN.BAZA05A set S_ULICA=''''',  1000 )@

UPDATE DB2ADMIN.BAZA05A SET REGION='' WHERE REGION IS NULL;
...
UPDATE DB2ADMIN.BAZA05A SET S_ULICA='' WHERE S_ULICA IS NULL;

call huge_upd(
  'SELECT REGION FROM DB2ADMIN.BAZA05A WHERE REGION IS NULL for update of REGION'
, 'update DB2ADMIN.BAZA05A set REGION=''''',  1000 );
...
call huge_upd(
  'SELECT S_ULICA FROM DB2ADMIN.BAZA05A WHERE S_ULICA IS NULL for update of S_ULICA'
, 'update DB2ADMIN.BAZA05A set S_ULICA=''''',  1000 );

CONNECT TO CLI_BDR13 user db2admin using xxxxxxxx@

create procedure huge_upd(
...
end@

connect reset@

db2 -td@ -vf crt_proc.ddl -z crt_proc.log

create procedure huge_upd(
  sel_stmt varchar( 1024 )
, upd_stmt varchar( 1024 )
, comm_cnt int)
begin
  declare SQLCODE int;
  declare dummy_var int;
  declare i int default  1 ;
  declare c1 cursor with hold for s;

  prepare s from sel_stmt;
  set upd_stmt = upd_stmt || ' where current of c1';
  open c1;
  fetch c1 into dummy_var;
  while SQLCODE!= 100  do
    execute immediate upd_stmt;
    if i=comm_cnt then 
      commit;
      set i= 1 ;
    else 
      set i=i+ 1 ;
    end if;
    fetch c1 into dummy_var;
  end while;
  commit;
  close c1;
end@

call huge_upd(
  'SELECT 1, REGION, ..., S_ULICA FROM DB2ADMIN.BAZA05A WHERE REGION IS NULL or ... or S_ULICA IS NULL FOR UPDATE OF REGION, ..., S_ULICA'
, 'UPDATE DB2ADMIN.BAZA05A SET (REGION, ..., S_ULICA)=('''', ..., '''')',  1 );

call huge_upd('select 1 from some_table where <condition>', 'delete from some_table',  1000 );