troubleshooting Question

Strange Stored Proc error

Avatar of Camillia
CamilliaFlag for United States of America asked on
IBM System iDB2
17 Comments2 Solutions1051 ViewsLast Modified:
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, 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...

Any ideas?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros