IQ8 calling Stored proc - returning cursor

[Former Member]

I am using IQ8 8.05c.

I want to call a stored procedure and return a cursor. I can't find anything in the docs on how to do this.

Can someone point me to some sample code?

Thanks,

Stephen

Denver, CO

[werner_daehn]

That's kind of a problem. DI does not have an array concept in the script language, so you cannot return a cursor there. Within a dataflow (query -> new function call) we support arrays, but only for very limited things like WebServices, SAP BAPI calls,... but not stored procedures. There is no real reason why we don't, it is just not implemented.

So you need something that lets you do custom SQL coding plus DI reading the data. Leaves two options: Create a database view that returns the stored procedure data - if the database even supports that. Or using a SQL Transform. The latter was successfully used in a SQL Server environment, that part I know.