Calling Teradata Stored procedure inTalend

[BA621858188]

Hi All,

I am using a Teradata stored procedure in Talend. I am using tdbrow to call the stored procedure statement. I have one OUT parameter, which I again need to use for further flow in the job.

How do I get the value of the OUT parameter from a stored procedure? Can anyone help here?

Thanks in advance.

[BA621858188]

Hi @Shicong Hong​ ,

can you please help here?

[Anonymous]

Hello,

As we don't have any specific tTeradataSP component in talend. You are able to use tDBSP component using generic JDBC connection. In jdbc conn you need to specify drivers and driver class specific to Teradata db. Passed input parameters using tfixedflowinput and cached output parameter using tJavaRow.

Feel free to let us know if it helps.

Best regards

Sabrina

[BA621858188]

@Xiaodi Shi​ 

How can I cache the output parameter? You mean I can directly use the OUT parameter name and store it in context?

[Anonymous]

Hello,

Yes you can use tDBSP to run the stored procedure and can store the result in output parameter and write the values in the next component.

For retrieving result set from a stored procedure, please try to link tDBSP to a tParseResultSet component, define a column with object type on schema of tDBSP.

Best regards

Sabrina

[BA621858188]

Hi @Xiaodi Shi​ ,

My IN parameter is coming from context value not from any schema.

How can I do now?

[Anonymous]

Hello,

Would you mind posting your job design screenshots here so that we could get more detailed information and workflow about your current situation.

Please mask your sensitive data if needed.

Best regards

Sabrina

[BA621858188]

Hi @Xiaodi Shi​ 

I won't be able to give you the design here because it's in another VM.

It seems that before tDBSCP, I need to use tfixedflowinput to store that context value as a column and then pass to the procedure.

Please correct me if I am wrong.