probelm with temp table

chettiar

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

Subscribe Post Reply

1466

Knut Stolze

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

Serge Rielau

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

Similar topics

Problem with a temp table

by: Jim | last post by:

For some reason the compiler is telling me that I must declarethe variable @costcenter_tmp on lines 74 and 98...but if i put a select statement in ther (for testing) before the loop I get data back...

Microsoft SQL Server

Temp Table in Stored Procedure with Access Report

by: Lauren Quantrell | last post by:

I have read the newsgroups and see this is a common issue but I saw no resolution for it: I have an Access2K frotn end and SQL Server 2K backend. In access, I create a temp table using code in a...

Microsoft Access / VBA

Can't get around temp table in front-end

by: Robert McEuen | last post by:

Using Access 97 on WinXP I have data in a DB2 table that I'm trying to get into an identical table in my backend db. Based on volume of data and frequency of download, I'm trying to avoid...

Microsoft Access / VBA

Temp tables vs table variables

by: serge | last post by:

I am running SQL Server Best Practices on a SQL 2000 database and it is recommending me to change the temp tables inside SPs to table variables. I had read already in other places to use table...

Microsoft SQL Server

Temp Table Faster?

by: wackyphill | last post by:

If you were doing paging of results on a web page and were interested in grabbing say records 10-20 of a result set. But also wanted to know the total # of records in the result set (so you could...

Microsoft SQL Server

Creating a dynamic Global Temp Table within a stored procedure

by: pukivruki | last post by:

hi, I wish to create a temporary table who's name is dynamic based on the argument. ALTER PROCEDURE . @PID1 VARCHAR(50), @PID2 VARCHAR(50), @TICKET VARCHAR(20)

Microsoft SQL Server

The age old argument of Temp table vs Table variable

by: Burbletrack | last post by:

Hi All, Hope someone can help me... Im trying to highlight the advantages of using table variables as apposed to temp tables within single scope. My manager seems to believe that table...

Microsoft SQL Server

Temp Table vs. Union: Which Has Better Performance?

by: imani_technology_spam | last post by:

Right now, a client of mine has a T-SQL statement that does the following: 1) Create a temp table. 2) Populate temp table with data from one table using an INSERT statement. 3) Populate temp...

Microsoft SQL Server

getting the probelm with updating the database

by: preeti13 | last post by:

i have a two tables employeenominations and reason if someone storing a data first time it will store into the employeenominations table if name is already exist it will store into the reason table...

.NET Framework

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

Development of Funny H5 Game - Toy Claw

by: kcodez | last post by:

As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...

HTML / CSS

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How does React native implement an English player?

by: lllomh | last post by:

How does React native implement an English player?

Mobile Development

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA