🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

How to call a stored procedure in DB2

llohmannllohmann Member Posts: 2 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 *
FROM (
   CALL Schema.NameOfProcedure(%{LOADING_SCHEMA}, %{LOADINGTABLE})
)"

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

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 709   Unicorn
    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
Sign In or Register to comment.