i have a problem call stored procedure from a server job via OLEDB from Microsoft .Net.
The simple job:
select * from Table1;
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.