Hi,
I am calling a DB2 stored procedure written in "C" (OS 390) from Java (AIX) using the callable statement. I am passing 2 output parameters back to the calling program. One of the output parameters is integer and other is char(80). I don't know for some reason the performance is very bad with the second character output parameter. 85 to 90% of the processing time has been spent on the SQLBindOutParameter method.
I would appreciate if someone help me in figuring out what the SQLBindOutParameter method does and ways to improve the performance.
I am not sure whether any of the db2connect parameters needs to be altered.
Thanks,
Veera
I am calling a DB2 stored procedure written in "C" (OS 390) from Java (AIX) using the callable statement. I am passing 2 output parameters back to the calling program. One of the output parameters is integer and other is char(80). I don't know for some reason the performance is very bad with the second character output parameter. 85 to 90% of the processing time has been spent on the SQLBindOutParameter method.
I would appreciate if someone help me in figuring out what the SQLBindOutParameter method does and ways to improve the performance.
I am not sure whether any of the db2connect parameters needs to be altered.
Thanks,
Veera