Spica
Reputation: 11
Call SQL Server stored procedure using IBM Integration Bus ESQL
I am new to IIB, trying to call SQL server stored procedure using ESQL. Could anyone share working example to call stored procedure which returns single value.
Upvotes: 1
Views: 7573
Answers (1)
Attila Repasi
Reputation: 1830
There are 2 ways you can call a stored procedure in ESQL:
- Define a procedure with the external keyword
https://www-01.ibm.com/support/knowledgecenter/SSMKHH_9.0.0/com.ibm.etools.mft.doc/ac17040_.htm
- Or use the PASSTHRU statement and call the stored procedure by putting the SQL command to call it into the parameter of the statement
Upvotes: 2
Related Questions
- iSeries - Call SQL stored procedure from CL program
- How to call a stored procedure in IBM System i Access for Windows GUI Tool
- Calling an oracle stored procedure from IBM API Connect
- SQL - Stored Procedure in IBM DB2
- Calling stored procedure on i Series using IBM DB2 Connect driver
- Calling an external AS400 stored procedure from C# with output parameter
- AS400 Call a stored procedure from another stored procedure
- using stored procedure in IBM I
- IBM i (AS400) Calling SQL Stored Procedure from STRSQL
- Stored Procedure on IBM i seems