Calling an ServiceProgram with a returnvalue

Hi all,

To call an iseries program or serviceprogram from .net, i wrap the call inside a storedprocedure, and then use that storedprocedure from my .net application.
Works like a charm, except, i can't figure out how to call a serviceprogram that has a return value.
something like this:
d DayOfWeek PR 1 0
d InputDate D DatFmt(*iso)
For any given date, it returns the day of week as a number;

I thought about wrapping it in a function, but i couldn't make that work.
I could of course, wrap such a function inside another storedprocedure, and add the returnvalue as an extra parameter, but i was wandering if somebody knew
howto do this.

I find it a bit strange that it is possible to call a subprocedure inside a serviceprogram directly, but that you cannot get at the returnvalue.
Perhaps there is some way to define this in the storedprocedure, but there is so little documentation about this.

I'm on a V5R3 machine, and i use IBM.Data.DB2.iSeries assembly.

thanks for all replies.

walter.hesius@xxxxxxxxx
+32 497 252 749
+32 2 335 2335
www.inxin.com