467,154 Members | 1,177 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,154 developers. It's quick & easy.

Stored procedures and Global temporary tables

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
  • viewed: 2693
Share:
1 Reply
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.

Similar topics

8 posts views Thread by C Kirby | last post: by
7 posts views Thread by pkruti@hotmail.com | last post: by
8 posts views Thread by Thomasb | last post: by
1 post views Thread by Roman Prigozhin | last post: by
3 posts views Thread by mandible | last post: by
1 post views Thread by peaceburn@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.