I would like to know if it is possible to install UDB / DB2 on CentOs.
TIA.
Andy

After searching google groups and the web, there seems to be no good answer
to this but I thought I would ask anyway.
Is there a way to programmatically test for a db2 connection, similar to
'db2 get connection status'?

I am using DB2 (version 7, soon to be updated to 8) on a mainframe that runs Z/OS.
It seems to me that the following query is legitimate, but I get an error message.
(This is not a real query; I'm just using it to experiment.)
SELECT CLASS, TYPE

Hi, List.
My company has a VERY BIG product base on db2 udb v7.x.
We want to di an upgrade to v9, but.... current db has a lot of
procedure (cobol..!).

Has anybody ever created a DB2 date function to convert a JDEdwards
date to a db2 date?
Example:
September 28 is 106271 in JDEdwards.

We're going to expand a COLUMN from a lookup TABLE, which is REFERENCEd
from three other TABLEs, from CHAR(2) to CHAR(5). It is the PK of the
lookup.
To do this, we plan to EXPORT the data, DROP the TABLE, (re-)CREATE the

Who have a explication or solution
My Email info@info-tact.com
Request #1 :
SELECT CASE WHEN nominal_total = 0 THEN 9.0 ELSE

   How obtain server (machine name) with db2 8.1.5 ?
I need get this name in select statement:
select (something)
from sysibm.sysdummy1

It is possible that we may be asked to restore a production tape, say 3
yrs later. We would prefer
redirect restore for that. I am documenting a process to do a redirect
restore. We take production backups via Legato.

I'm using stored procedures in DB2 UDB 8.1.2. In this stored, I execute
a select for update command, opening a cursor. Then I update the rows
using fetch and current of. The problem is that I want to return the
rows for my Java application. But if I set the cursor of the select for

I have a sql query, i want to create a .bat file to execute the query.
Also i would like to know how to run the file.
Can anybody can help me with this?

I have been using the db2 export function for quite sometimes.
Everytime I want to use it I have to remove every carriage return from
my SQL statement and have it all on one line as shown in the following
simplistic example:

I have been using the export command for quite some times to export
comma delimited file.  I have always been looking at how to generate
the first row with the column header but never found a clean way to do
it.  I have searched this newsgroup and the only suggestion found was

I 'recreated' a stored procedure.
Earlier, i had given privileges to a particular group but now (after
rebuilding) when I try to grant execute privilege for the SP to the same
user group, it gives me the below message.

I use db2jcc.jar from 8.1 client.
Is there a way to set up timeout before executing statement?
statement.setQueryTimeout does not timeout on execution of
statement.execute.