Re: Calling Db2 for i stored proc with Named parameters from C# using Db2 connect .NET driver

Sounds to me like C# is not using the correct parameter types. This is
VB.NET code, but your C# guys should be able to make sense of it.

db2DataAdapter.SelectCommand = db2Connection.CreateCommand()
db2DataAdapter.SelectCommand.CommandText = "MYLIB.MYSP"
db2DataAdapter.SelectCommand.CommandType =
CommandType.StoredProcedure

db2DataAdapter.SelectCommand.Parameters.Add("Parm1",
iDB2DbType.iDB2Char, 25)
db2DataAdapter.SelectCommand.Parameters("Parm1").Direction =
ParameterDirection.InputOutput
db2DataAdapter.SelectCommand.Parameters("Parm1").Value = request
db2DataAdapter.SelectCommand.Parameters.Add("Parm2",
iDB2DbType.iDB2VarChar, 5500)
db2DataAdapter.SelectCommand.Parameters("Parm2").Direction =
ParameterDirection.Input
db2DataAdapter.SelectCommand.Parameters("Parm2").Value = inputParm

db2DataReader = db2DataAdapter.SelectCommand.ExecuteReader()




-----Original Message-----
From: Charles Wilt [mailto:charles.wilt@xxxxxxxxx]
Sent: Tuesday, May 15, 2018 12:36 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Calling Db2 for i stored proc with Named parameters from C# using
Db2 connect .NET driver

All,

Has anybody got a exmaple of calling a Db2 for i stored procedure with
named parameters from a C# app using the Db2 connect .NET driver?

We've tried a few ways, but we keep seeing a Sqlstate => 42884 - No
routine was found with the specified name and compatible arguments.

with a performance monitor running, I can see that the "PREPARE" call is
being done without using parameter names.
PREPARE "CALL MYLIB.MYSP(?,?,?)

instead of
PREPARE "CALL MYLIB.MYSP(p1=>?,p2=>?,p3=>?)"

I'm not the .NET guy having the issue, I'm the guy that wrote the SP and
is trying to help. :)

Thanks!
Charles

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD