Host result variables

These variables receive the results of select and fetch statements.

The following example uses the TITLE-ID variable as a result variable:

exec sql begin declare section end-exec  

 01  TITLE-ID           PIC X(6). 

 exec sql end declare section end-exec 

 exec sql select title_id into :TITLE-ID from titles 

      where pub_id = "0736"  

      and type = "business" end-exec.