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