I'd like to build a form which does a case insensitive wild card search
on a character field.  For example, the resulting SQL might be 'select
last_name from student where ucase(last_name) like '%SMITH%', where the
"SMITH" is a search string pulled from the form.  That is, I'd like ...

I have two databases in DB2 v8.2 (Windows 2003 Server platform) and right
now both databases are on my c-drive.
Unfortunately space on this drive is becoming low and I want to relocate the
databases to my d-drive.

Does DB2 UDB support parallel database i.e processing is taking place
on multiple nodes at the same time allowing users to be active on more
than one node simultaneously. This is to allow for failover as well as
load balancing?

hi people i am facing a problem, when i am converting SQL server sql to
db2 v7.2 SQL the existing sql server command is
SELECT
  isnull(u.NAME, 'NO USERS') USERNAME,

I am having a problem with an index controlled partitioned table.  I
was altering a table using SQL.  I was trying to add a partition to a
table to change it from index controlled to table controlled.  This is
a new feature in version 8.  Version 8 will automatically switch the

Is there some way to track the isolation level of an indivual SQL
statement submitted via JDBC in a snaphot or some other similar means?
I have JDBC programs that are changing the isolation level via
Connection.setTransactionIsolation(int level) method, such as

We have a process ( a stored proc)  that exports data ( about 10
million records) from a huge table,t1 and loads it into another huge
table t2. The export runs for 3 hours everyday because of a very
complex sql...

Can we create a report of this format using DB2.
Report#
Date:
                      column1        column2        column3

Am I expected to receive alert (configured via email notification) as
soon as it is triggered?
I have received alert of 'spilled sort' at a time where nothing is
running.

Can we create a partitioned table with MDC feature. Please let me know
how that works.

I am tring to clean up data in some of our fields. The requirement is
to only have letter (a-z,A-Z) and number (0-9) characters in the
field...
So, if we select from the non-cleaned-up field, we may get A_p@;Pl%e2

can the technique I have seen here and elsewhere to solve the
case-insensitive search problem with db2 be implemented in z/os?
for example...
alter table individual

I'm working on DB2 UDB 8.1 for AIX 5.3. I tried to do either db2 drop
database mydb or connect to mydb command after I restored mydb from an online
backup image using redirected restore. I got the following error:
SQL1031N  The database directory cannot be found on the indicated ...

  i am doing a report generation work in which i take the count of two
columns. and i need to calculate the difference of the counted value as
a new column. for example in SQL we use
<B>difference(count(a.column1),count(a.column2)) as alias <B>

I want to get my db2 instance's listen port,
is there any command to retrieve this information?