Could not execute statement.
No primary key value for foreign key '*column_name*' in table '*table_name*'
SQLCODE=-203, ODBC 3 State="42000"
Line 1, column 1
(Continuing after error)

begin
declare li_inv_id integer;
    set li_inv_id=(select min(id) from inv where user_111_flag = 0 and id <> 0);
  cycle_loop:
  while li_inv_id is not null loop
  message li_inv_id type status to client;
   set temporary option on_error = 'continue';
    delete from inv where id = li_inv_id;
        if sqlcode < 0 then
      unload select "left"(getdate(*),19) || ';id=' || li_inv_id || ';SQLCODE:' || sqlcode || '\x0A' from dummy to 'e:\\delete_inv.csv' append on delimited by ',' escapes off quotes off;
      rollback work;
      set li_inv_id=(select min(id) from inv where user_111_flag = 0 and id > li_inv_id)
    else
      commit work;
      if sqlcode < 0 then
        unload select "left"(getdate(*),19) || ';id=' || li_inv_id || ';SQLCODE:' || sqlcode || '\x0A' from dummy to 'e:\\delete_inv.csv' append on delimited by ',' escapes off quotes off;
        rollback work;
        set li_inv_id=(select min(id) from inv where user_111_flag = 0 and id > li_inv_id)
      else
        unload select "left"(getdate(*),19) || ';id=' || li_inv_id || ';SQLCODE:' || sqlcode || '\x0A' from dummy to 'e:\\delete_inv.csv' append on delimited by ',' escapes off quotes off;
        set li_inv_id=(select min(id) from inv where user_111_flag = 0 and id > li_inv_id)
      end if 
    end if
  end loop cycle_loop
end