In my current job I use a Sql Server stored procedure with 2 input parameters, the stored procedure calls a table-valued functions and passes it the 2 input parameter. The table-valued function returns 6 columns with values and I finally get these 6 values in my stored procedure/function call.
Now I want to do the same exact process but with Sybase ASE. But it seems like Sybase ASE does not support table-valued functions but only scalar functions. Is there anyway I can do this in Sybase ASE where I use a stored proc with 2 params, which calls a function and passes it the 2 input params and then fetches multiple columns with values. Any suggestions would be appreciated. Thanks.
Using Sybase ASE 16.x.
brotherbob (BOB member since 2012-04-18)