How to Call AS400 stored procedure with input and output parameters

[IanCrueldad]

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

[Anonymous]

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 🙂

[IanCrueldad]

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?

[IanCrueldad]

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?

[Anonymous]

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 🙂

[IanCrueldad · Accepted solution]

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