I have three queries.
If the counts returned from the first and second queries are equal
then the third query is executed.
Is it possible to get this information in a single query without

I have inherited a large application.
I have a table which contains a hierarchy, like this
CREATE TABLE sample_table(
sample_id int NOT NULL

I figure someone else may have use for this toy, so here goes:
Prereq: DB2 V8.1 FP4
CREATE PROCEDURE DELETE_MANY_ROWS
(tabschema VARCHAR(128),

I'm trying to find if there is any performance diference between
explicitly using a sequence in the insert statement to generate values
for a column and doing this in an insert trigger.
I noticed that th eaccess plan for the 2 situations is quite

Suppose I am an admin of a database instance. Now
I need to specify that user A  has the right to create tables
in his own schema, but not anywhere else.
In order to let user A  create tables, i grant createtab to that user.

The sentence "If you are an HACMP™ user, you must use the ha_db2stop
command to stop DB2 instead of the db2stop command. If you use the
db2stop command instead of the ha_db2stop command, you will trigger a
failure event.". If I also do HADR with HACMP, should I also use the

Using the IBM Universal JDBC (Type 4) driver;
Can one specify a default schema as part of the url?
Some application servers do not allow sending a default sql command
upon connection, so I can't rely on 'set schema xyz', hence the need

I have already checked the URL http://www-306.ibm.com/software/data/db2/9/sysreqs.html.
There are no Operating System need to install C rumtime environment
components other than AIX before installing DB2 Server product. Is it
specific for AIX only?

Folks,
 I am having trouble with a query. DB2 does not use index, it does relation
 scan of the table.
 I am running DB2 UDB 8.2 on Fedora Core release 4 (Stentz)

DB2 V8.2 on AIX
I am looking for an efficient way to update several columns in a table
that will have a default change.  The problem is the table is large
(million records) and there are 1 to 4 columns that might need to be

My environment is DB2v9.1, Windows/AIX and I am trying to compile the
stored proc below and I am getting an error, "ERROR [42601] [IBM][DB2/
NT] SQL0104N  An unexpected token "WITH" was found following "User_ID
= UsrID;      ".  Expected tokens may include:  "SELECT".  LINE

I have the following sql/pl:
CREATE PROCEDURE DBSTG.TEST
(OUT PRESULT INTEGER
)

I lack knowledge about triggers.
I have created trigger on table A
Table A
-------------------------------------------------

I come from the oracle world and would use the Oracle 'DECODE'
function
extensively. Is there any equivalent in db2???
using db2 version 8.1 on win

DB2 UDB 8.X on Windows server
A couple of questions:
1.)  I am trying to develop some DB2 SQL stored procedures.  Dev
environment at UDB v 8.2,