Host output variables

These variables pass data from stored procedures to the application program. For more information on stored procedures, see “Using Stored Procedures” on page 6-11. 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;