Exec stored procedure SQL DB2 for I(AS400) in Qlik Sense

[Ramajola]

Hello guys, I need to launch a stored procedure created on the AS400 DB2 for I platform. Whenever I try to launch, do I get the following error? Is there a way to do this?

The rest of the queries run without any kind of problem.

Any suggestion? 

Thanks in advance

[Ramajola]

Any news for this topic?

[ArnadoSandoval]

Hi @Ramajola 

Can you tell us more about the store procedure? Does it return a single value or a dataset of records? I am not that fluent in Italian, but the message seems to tell us that the connection was successful but the store procedure violates a rule for a single lecture, Would you translate the message for us? 

If the stored procedure returns a dataset, would it be possible to write those records to a table at the database, then Qlik read that table or replace the store procedure to a view (I can't guide on what's better a view or table because I do not know what it is doing)

Hope this helps,