The SQL statement below returns the single value "8000k/1000k".
select col1 from table1 fetch first 1 row only for read only with ur;
COL1
----------------

I need to find the pricing for WGE and ESE(old name) If anyone can point me
in the right direction.
Also, are DUO chips counted as two, like the xeons from Intel?
Thanks in advance

Hello, all.
DB2 v8.2.7, DB2 v9.1.3, Windows XP.
When I choose this menu item (this menu appears when I right click a
database)  in db2cc nothing is happening on both versions of db2cc.

Picking up on an old thread available at http://groups.google.com/group/
comp.databases.ibm-db2/browse_frm/thread/b2d4cc44f3e4e734 concerning how
to create functionality to return a DATE-typed value from a valid date-
string, but NULL for invalid date strings:

Hi, I'm new at this so I could use some advice. I need to call 1 or
possible 2 DB2 z/os stored procedures from SQL Server 2005. What is
the best way to accomplish this? This also needs to run at least once
a day automatically.

My input data is csv file like this with '|' delimiter:
1|first
2|second
3|third

I am interested in failover for DB2 Version 9 on an AIX environment.
Can you give me any recommendations?

MERGE INTO MyTable as nd USING
(with tex (ID, acc_num) as ( values ('1','acc232'), ('2','acc8993'),
('3','acc543') )
select ID, acc_num from tex

I am running my application on Windows.
Developed in C++.
The DB2 V8 database is installed on MVS mainframes.
DB2 Client is installed on Windows.

I wanted to put check for the existing table. I got the table entry in
two different tables.
1. SYSCAT.TABLES
2. SYSIBM.TABLES

I'm new in using DB2 and I have question on creating/ altering table.
I created a file (DDL) with SQL statements, then the database
administrator (my client) to create or alter the table automatically
by running the command "db2 -tvf <filename>".

I have two tables...Table1(name, date); Table2(appointment_name, name,
appointment_date).
I want to update appointment_date in Table2 with date from Table1
(business requirement). I am trying to write a Update statement, I

We have an application under which different rows are being accessed on
the same table at the same time, by two seperate Java application
threads each with its own connection to the DB2 database.
The fact that the rows are different and we have row level locking

Environment: DB2 LUW v8 FP15 / Linux
I have a table with 50+ Million rows. The table structure is basically
(ID - Timestamp). I have two main applications - one inserting rows,
and the other reading/deleting rows.

Found the following in an error log:
ADM5571W DB2 is marking object "0" of table "I810ZZ1.GL00998Z"
unavailable. This table will have to be dropped.
I can't find what causes the message.