When the "new" data IS NOT NULL or whenever the row is stored? In
particular is the first clause needed in:
ALTER TABLE IS3.FLUSHES
    ADD CONSTRAINT PALP_LEFT_OV

DB2ers,
I am a newbie to DB2 world. I just built a test DB2 server and
installed the "SAMPLE" database. It turns out the database was created
under my ownership. As a result, if some other user tries to fetch

row_count - is it total inserted,updated or deleted by merge statement?
Any way get different counts?
Andy

I have 2 insert statements within a procedure which are as follows:
INSERT INTO temp table (column1, col2 )
     SELECT 'abc, 'b'      FROM tab1 AS A
       WHERE A.col1 = '0' --20030801

DB2ers,
In my setup, DB2 server is installed on a Windows box "test16"
and "SAMPLE" database has been loaded.
Now, on a clean Windows machine (test15), I installed DB2 client

DB2ers,
I am a newbie to DB2 but have enough experience with other database
servers. Many database servers such as SQLServer offer a dual-mode
authentication mechanism, that is, either you can use standard Windows

Environment:
AIX 4.3.3
DB2 UDB WSE version 8.1 fixpack 9a
When I access a database residing on this server from my workstation (Windows xp, servicepack2 - db2 udb ESE fixpack 10) and in Control Center try to list the tablespaces (click on Tablespaces in the left part of the GUI) I ...

All.
We have a Client/Server environment on with PB/Sybase and we are
looking at moving to PB/DB2.
What are the things we need to consider for

 I am attemting to write some Visual Basic Scripts that will call a
DB2 stored procedure and get the return value.
 The test scripts are shown below. Not sure why I cannot get the
returned value. I know the procedure is running as I had put in a line

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.

I have a laptop with windows xp 1 gig ram 2.0 pentium M.  When I run
the db2 personal edition version 8.2 the install gets to the first
screen and says windows installer is preparing to install.  There is a
back next and cancel button on the screen at the bottom.  The next and

DB2 WSE LUW 8.1 FP5
Red Hat AS 2.1
I would like to grant a new database user the same privileges
(across many tables and views) that a current user has.

I've got a set of redundant marts that I'm trying to catalog on the
client side to allow us to do two things:
1.  manually recatalog to point at either of the two fast marts
2.  automatically failover to a third slow mart

Running DB2 8.2 on AIX 5.2.
If you have more than one instance on a box is there a way that can be
used to determine which is the name for the fenced user for a
particular instance?

I'm pretty sure the tasks that are in the task center are in a table
somewhere, but I'm not finding them. Any ideas?