Hiya,
Yes, GTT are used in stored procedures.
Values can be inserted into them.
As far as return to DB2 inconcerned, that should be possbile as a return of a result set.
regards,
rinku
Hi Hope this will help more peolpe...
We got a new design where we use Global temporary tables(GTT) inside stored procedure... My question is can we use GTT inside a stored procedure and insert values in to it? Can we fetch multiple rows from that GTT and return it from DB2(Note: My stored procedure is created in DB2)?
Please help me out ...