I cannot use the load cmd inside a stored procedure, got this error
declare cursor_x cursor for select cod, name, hired project from emp.table_1;
load from cursor_x of cursor insert into emp.table_2 nonrecoverable
Without load it is working fine.
{0:0} An unexpected token "from" was found following "emp.table_1
load". Expected tokens may include: "WHERE".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.25.1301
Without load it is working fine.