topic How to Call AS400 stored procedure with input and output parameters in Talend Studio

How to Call AS400 stored procedure with input and output parameters

IanCrueldad — Sat, 16 Nov 2024 05:25:50 GMT

How to Call AS400 stored procedure with input and output parameters?

Re: How to Call AS400 stored procedure with input and output parameters

Anonymous — Fri, 28 Jun 2019 23:27:49 GMT

Hi,

You will have to use tAS400Row where you can pass the input parameters through context records and the output values can be captured through schema defined for the component. Please refer below link for help guide related to the component.

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/K3IOiaWSwPhymQXmuRcxHg

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to Call AS400 stored procedure with input and output parameters

IanCrueldad — Mon, 01 Jul 2019 21:14:08 GMT

Hi Nikhil ,

I tried using AS400Row. It doesn't seems to be working in my case. I have this As400 sp TestEvent(EvtId => ? , Event => 'Test')

Here Evtd is output parameter and Event is input Parameter. Please advice how can I use context variable in this case?

Re: How to Call AS400 stored procedure with input and output parameters

IanCrueldad — Wed, 03 Jul 2019 14:10:16 GMT

Hi Nikhil ,

I tried using AS400Row. It doesn't seems to be working in my case. I have this As400 sp TestEvent(EvtId => ? , Event => 'Test')

Here Evtd is output parameter and Event is input Parameter. Please advice how can I use context variable in this case?

Re: How to Call AS400 stored procedure with input and output parameters

Anonymous — Wed, 03 Jul 2019 15:04:10 GMT

Hi,

I have not personally worked in AS400 technology. So for exact syntax, lets check with @xdshi

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to Call AS400 stored procedure with input and output parameters

IanCrueldad — Thu, 11 Jul 2019 17:37:08 GMT

I am able to resolve this problem. To call AS400 stored proc we don have any specific tAS400SP component in talend. I used tDBsp component using generic JDBC connection. In jdbc conn we need to specify drivers and driver class specific to AS400 db. Passed input parameters using tfixedflowinput and cached output parameter using tjavaRow