How to call a stored procedure in DB2
Contributor I
Hello everyone,
I found this Question:https://community.www.turtlecreekpls.com/discussion/29665/execute-stored-procedure-with-read-database-operator
Which is already helpful, but it doesn't work in my context, bc I think its an oracle DB in their case. In my case I have a DB2 stored procedure and I want to call it, to get something back in RM Studio.
So what I've tried is the following:
Read DB Operator with SQL Code:
"SELECT *
I found this Question:https://community.www.turtlecreekpls.com/discussion/29665/execute-stored-procedure-with-read-database-operator
Which is already helpful, but it doesn't work in my context, bc I think its an oracle DB in their case. In my case I have a DB2 stored procedure and I want to call it, to get something back in RM Studio.
So what I've tried is the following:
Read DB Operator with SQL Code:
"SELECT *
FROM (
CALL Schema.NameOfProcedure(%{LOADING_SCHEMA}, %{LOADINGTABLE})
)"
Is my Syntax messed up? Because I'll always get an error.
Is my Syntax messed up? Because I'll always get an error.
0
Answers
there could be many problems.
Does the query work in a native SQL client? Does it work with the actual parameters in RapidMiner (instead of the macros)? Maybe you need to quote the macro values with single quotes? '%{LOADING_SCHEMA}' etc.
What does the error message say? Do you find additional information in the log of the database server?
Regards,
Balázs