Host output variables

These variables pass data from stored procedures to the application program. Use host output variables when stored procedures return the value of parameters declared as out.

The following example uses the variables par1 and par2 as output variables:

exec sql exec a_proc :par1 out, :par2 out;