ENDSELECT Example
Break out of a select loop on a data loading error:
exec sql select ename, eno into :ename, :eno
from employee;
exec sql begin;
load ename, eno into data set;
if error then
print 'Error loading ', ename, eno;
exec sql endselect;
end if
exec sql end;
/* endselect transfers control to here */
Last modified date: 12/12/2024