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