EXEC SQL declare q_curs cursor for select lname, company from customer; EXEC SQL open q_curs; while (SQLCODE == 0) EXEC SQL fetch q_curs into :p_lname, :p_company; EXEC SQL close q_curs;