Is it possible to Query an MS SQL Table Valued Function from Tibco DV

[Clayton Beatty]

I am very new to Tibco DV... as in, I first saw the product yesterday.... and I am wondering if it is possible to query data from a Table Valued Functiion in a SQL database I'm thinking it is... but am not having any luck in doing it.

The SQL function has already been connected to Tibco (by another team), and when I open the function in Tibco, under the datasource... I see two variables defined; the first being the table return value (OTHER/table), and the second being the sole input paramter which is needed by the function (DATE/date).

When I look at the Info tab, Yibco seems to see the Type as being: Procedure

Executing a select against the function within MS Management studio returns the expected data (of course):

select *

from MySchema.fnMyFunction('2019-06-04')

But when I use SQL scratchpad to execute from within Tibco:

select *

from /Path0/Path1/Path2/Path3/Path4/Path5/Path6/fnMyFunction('2019-06-04')

I get the following message:

Procedure

'/Path0/Path1/Path2/Path3/Path4/Path5/Path6/fnMyFunction'

must contain only one output cursor with unique fields or at least one scalar output. On line

2, column 6. [parser-2906438] [Log ID: 61835d25-0a12-40a9-a8f1-38eb6a39eaef]

And when I open the Tibco definition of the function, and click the run icon... I am prompted for the input parm, and then I get:

null [Log ID: a44d5887-2d22-4c3f-b42c-6d14bfafbc08]

 

As I said, I am very new to Tibco DV, so I know almost nothing about it... But I am an MS SQL develeoper. Any thoughts or advice would be appreciated!

[Deepak Kuletha]

Hi,

 

Please let me know the data source type which you have created.

 

Is it a stored procedure that you see under Data Source  

 

Did you try design by example for the same