DB2 zos stored procedure support

shailesh bhaskaran

unread,

Jan 19, 2016, 3:19:53 AM1/19/16

to node-ibm_db

Hi,

Would the driver be able to support invocation of DB2 zOS native SQL stored procedure which returning resultsets?

Regards

bimaljha

unread,

Jan 19, 2016, 7:07:23 AM1/19/16

to node-ibm_db

Hi Shailesh,

node-ibm_db does not support OUT or INOUT params in Stored procedure call, so you can't get resultset from server using ibm-db.

Thanks and Regards,

Bimal Jha

shailesh bhaskaran

unread,

Jan 21, 2016, 8:34:32 AM1/21/16

to node-ibm_db

Hi Bimal,

Are there any plans to include the support for stored procedures with OUT/INOUT parms in node-ibm_db in near future? I assume DB2 stored procedures are very commonly used and it will help many if this package can start supporting SP's

Regards

Shailesh

bimaljha

unread,

Jan 22, 2016, 7:45:23 AM1/22/16

to node-ibm_db

Hi Shailesh,

Currently, there is no plan. Based on user request we prioritize the enhancements. Requesting you to share your info here: http://goo.gl/forms/EKzg7A6HZw

Thanks and Regards,
Bimal Jha

bimaljha

unread,

Oct 31, 2016, 5:45:56 PM10/31/16

to node-ibm_db

ibm...@1.0.1 is released with OUT and INOUT parameter support for Stored Procedure. Please try it. Thanks.

On Thursday, January 21, 2016 at 7:04:32 PM UTC+5:30, shailesh bhaskaran wrote:

Reply all

Reply to author

Forward