Host result variables

These variables receive the results of select and fetch statements.

The following example uses the variable id as a result variable:

exec sql begin declare section;
 CS_CHAR  id[5];
 exec sql end declare section;
  
 exec sql select title_id into :id from titles
     where pub_id = "0736" and type = "business";