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

[rob@xxxxxxxxx]

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