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

1483

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

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware