Figure 2 – Extended indicator

EXEC SQL DECLARE cur1 CURSOR WITH EXTENDED INDICATORS FOR

         SELECT order_id,shipdate,quantity,status FROM orders;



EXEC SQL OPEN cur1;

EXEC SQL FETCH cur1 INTO :orddat:inds;

…

inds2 = -7;

EXEC SQL UPDATE employee

        SET shipdate = :nsdate:inds1, quantity = :nqty:inds2,

            status = :nstat:inds3

        WHERE CURRENT OF cur1;

…