stored procedures MUST be coded with errbuf and retcode OUT parameters
which MUST be defined as first parameters of your procedure if you want to
use the procedure as concurrent request.
errbuf parameter comes first, retcode comes second, then the rest of your
Populate retcode with 0 if logic within your procedure completes successful,
use 2 if the program ran into an exception (either a logic exception or when
an unexpected error should occurr) and use 1 for retcode, if your logic
should indicate a warning such as "no data found for processing" or something
When defining concurrent program in sysadmin responsibility do NOT define
parameters for errbuf and retcode, only for the rest of your parameters.
That's all - in short.