72
Cursors
•void product2XML() {
• EXEC SQL BEGIN DECLARE SECTION;
•              char n[20], c[30];
•              int p, q;
•              char    SQLSTATE[6];
• EXEC SQL END DECLARE SECTION;
•
•EXEC SQL DECLARE crs CURSOR FOR
• SELECT pname, price, quantity, maker
• FROM Product;
•
• EXEC SQL OPEN crs;