I need some more information on the table function example 2.

As in Oracle I take data into collection (bulk collect) and then use the
collection as table in other queries, for example I take all the Childs of a
parentid and use it through out function instead of querying multiple times.
And assign the required output to another object (types) and then get output
of the data by returning the collection.

In MSSQL we converted the functions by declaring tables and inserting the
data into those tables to use in queries, same as above to store the Childs.
Finally insert the required output into the table declared for returning.

For the purpose only I given example of mssql how we are inserting the data
into the declared table in the function and returning the table.

I hope I could somewhat able to put forward my requirement. Please give me a
one simple example. It will be of a great help to me and I will be able do
finish conversion in time.

Mujeeb


DB2 & UDB email list listserv db2-l LazyDBA home page