Re: Call Parameterize iSeries Store Procedure from .NET C#

That is COBOL code. What we are looking for is the code he used for
CREATE PROCEDURE. There is a way to create a sql stored procedure which
will execute a COBOL program. We really need to see how the parameters
are defined there.
Another problem with his snippet of COBOL code is he left out the (excuse
me, my COBOL is rusty) DATA section. From there we need to see the 'PIC'
of the parameters passed into this COBOL program.

One good reason why this may work from a command line but not elsewhere is
that SQL procedures support 'overloading'. What this means is that you
can have multiple procedures with the exact same name, capitalization and
all. But based solely on the parameters it will execute different ones.
For example, if I can create a procedure called GIMMIEDATE a couple
different ways. Once with a 8 character parameter, once with a 8 digit
parameter, once with a 6 character parameter, once with a 6 digit
parameter. And it will execute the right one based on the parameter type
you send it. If you try to send it a 10 character parameter it will tell
you that GIMMEDATE is not found. It won't say there's a parameter
mismatch. This is a common mistake when trying something from the command
line versus elsewhere.


Rob Berendt