EXEC SQL DECLARE cursor CURSOR FOR ‘SELECT * FROM table - ‘WHERE COL1 = ‘‘ABCD’’; - ‘UPDATE “table one” SET COL2 = ’’ABCD’’’ END-EXEC
EXEC SQL DECLARE cursor CURSOR FOR ‘SELECT * FROM table - ‘WHERE COL1 = ‘‘ABCD’’; - ‘UPDATE “table one” SET COL2 = ’’ABCD’’’ END-EXEC