How to call a stored procedure in DB2

llohmann

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 *

FROM (

   CALL Schema.NameOfProcedure(%{LOADING_SCHEMA}, %{LOADINGTABLE})

)"

Is my Syntax messed up? Because I'll always get an error.

BalazsBaranyRM

Hi,

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