To call a stored procedure or function in a Talend job, you can use the tSQ

How to call stored procedure and function in talend job

Question Posted / Gaurav Singh Sengar

1 Answers
2 Views
I also Faced
E-Mail Answers

Answer Posted / Gaurav Singh Sengar

To call a stored procedure or function in a Talend job, you can use the tSQLRow component. Here's how:n1. Add a tSQLRow component to your job design.n2. Configure the connection parameters (database type, host, port, username, and password).n3. In the 'Query' field, write the call to the stored procedure or function. For example: `CALL myProcedure(?)` or `SELECT myFunction()`. Replace 'myProcedure' and 'myFunction' with your stored procedure or function names.n4. Set the input parameter if required (using the 'Input Parameters' tab).n5. Preview the data to verify the call.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !! You can

Post New Questions

Answer Questions in Different Category