Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
How to call a stored procedure in DB2
Contributor I
Hello everyone,
I found this Question: https://community.rapidminer.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.rapidminer.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