Hi all,

i have a problem call stored procedure from a server job via OLEDB from Microsoft .Net.
The simple job:

select * from Table1;
call MyProc;
select * from Table2;

stops every time after the call statement witout an error. The stored procedure is successfully called, but i always get 1 result set.
If i comment the call statement out i return 2 result sets.
Running this example from a db2cmd is successful too.

What do i make wrong ?


Thomas

PS: sorry for my bad english