imported sql function returning a table

dataservices job design
1

I have imported a SQL function from a Datastore that returns a table, but on having made it Data Services returns the following message to me:

Parameter XXXXX of stored procedure YYYYY is ommited, so you cannot provide or retrieve value from to or from the parameter. You may get database errors when you call the procedure…

Does DS support this functionality?

Do I need to realize some previous step, like to create a file format or similar?

aperezs (BOB member since 2009-09-09)

2

Simply not supported. Stored Procedures return scalar value, fine. But arrays not. Some people use SQL Transform as a workaround it was said in the forum here somewhere.

Werner Daehn :de: (BOB member since 2004-12-17)