469,323 Members | 1,667 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

probelm with temp table

Hi,

I am creating a temp table within a procedure and inserting some
records based on some conditions. Is there a way I can query the temp
table to see how many records have been inserted when the procedure is
being executed.

Nov 12 '05 #1
2 1380
chettiar wrote:
Hi,

I am creating a temp table within a procedure and inserting some
records based on some conditions. Is there a way I can query the temp
table to see how many records have been inserted when the procedure is
being executed.


SELECT COUNT(*) FROM <temp-table>

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2
chettiar wrote:
Hi,

I am creating a temp table within a procedure and inserting some
records based on some conditions. Is there a way I can query the temp
table to see how many records have been inserted when the procedure is
being executed.

You mean from the outside? No way. The idea of the temp table is that it
is private to the session.
But if you want to knwo which crooked paths your procedure is taking
have a look at the SQL PL Debugger that comes with the Development
Center, or check out my SQL PL Tracing facility. You can find it by
searcging for "Rielau" at www.ibm.com

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Jim | last post: by
1 post views Thread by Robert McEuen | last post: by
1 post views Thread by serge | last post: by
5 posts views Thread by wackyphill | last post: by
1 post views Thread by imani_technology_spam | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.