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. For more information on stored procedures, see “Using stored procedures”.

The following example uses the PAR1 and PAR2 variables as output variables:

exec sql exec a_proc :PAR1 out, :PAR2 out end-exec.