I've been writing AS400 stored procs and calling them my .Net app using IBM.DB2.iSeries dll.
I wrote another one but this time, we wanted to call it from our propriatory vendor app. We got an error saying..TCP/IP connection lost.
We did some tests and found out this:
I open iSeries Navigator and call the stored proc. It works fine.
My coworker used strsql and called it . it worked fine.
When we call it with NO parameters, it works fine.
Calling As400 from .Net app works fine.
Calling SQL Server stored proc from the vendor app works fine.
we found out that when AS400 SQL stored proc is compiled on AS400..somehow, it adds more parameters to the list. We dont see the parameters but it adds them . (My coworker found this out..how, dont know).
We called IBM and they said to do it in CL something.
Anyone has any ideas on what to do? My coworker says the .Net app calling AS400 stored proc works because the IBM.DB2.iSeries dll knows what to do...knows how to bypass the "extra" parameters created when the AS400 Stored proc is created...