By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Stored procedures and Global temporary tables

P: 4
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 ...
Sep 6 '07 #1
Share this Question
Share on Google+
1 Reply


P: 5
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 ...
Sep 7 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.