OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Statements > ENDSELECT > ENDSELECT Example
Was this helpful?
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: 01/30/2023