I tried to create a stored procedure on the AS/400 - but it doesn't work ;o(
At first I will validate a specific value by a Param-value and after that
update it.
At least I want to return a resultset. But the DB2 tells me "[SQL0104] Token

So I'm trying to make an application that currently works with MySql,
Postgre, etc... work with DB2.
THe problem I have, is, the varchar column only goes to 32k. CLOB goes
bigger, but at a major cost. SELECT DISTINCT, UPPER,LOWER, ORDER BY,

Is there anyone who can address me to the official (or not)
documentation for Fixpack 13 Installation on a IBM DB2 connect
enterprise server?
Many thanks.

We are using UDB 8.2 on Windows.
With RUNSTATS you can specify ALLOW READ or WRITE ACCESS. But this is
optional. What if you don't specify any of this? What's the default? I
can find that information in the manual. Does anybody know?

Environment: db2 V8 FP 13 LUW
Our application currently uses:
insert into table values ('A'),('B'),...('Z')
We have used CLI arrays inserts (1000 array and commit size) and

I am working on an audit trail mechanism for an MS-Access application
that connects to a DB2 backend. We need the APPLICATION_ID to remain
constant until the application is terminated. It appears that DB2
connections expire after some duration and new ones are created when

Dear Friends
Currently in our environment we are using db2 udb v8 with fix pak 7. we
are planning to move to fix pak 12.
Before that i would like to know what are the enhancements between this

I have recently installed DB2 express on UBUNTU and am not able to get
it to start. I decided to uninstall and reinstall DB2. When I enter the
command sudo ./db2_deinstall it says "No DB2 Packages found on this
system...."  Please help me.  I am new to DB2 on Unix.

On one machine I have DB2 8.2.4 and on one I have DB2 9.1.
If I run db2look from the DB2 9.1 machine against a database that is on the
DB2 8.2.4 I get:
SQL5060N  The configuration parameter token specified is invalid.

Why do I have a zero result on this query for all non-zero rows? Do I
have to declare specifically the precision of ratio division? How do I
do that? And is there a way to make DB2 'ignore' division by zero and
just punch up a 0 result where such division is encountered so that I ...

I'm trying to fix up a database on my server by transferring all the
readable data to a new database, and then upgrading it from db2-7 to
db2-8.  I'm using the export command to dump the tables that I'm having
a hard time with to a file, then running the LOAD command on those

db2 8.2.4,windows
Is there any way of formatting numerical fields in currency format.I want
to display the salary or employees like $200,000.Is there any inbuilt
function in db2 for this(In oracle, I guess this is done using TO_CHAR

The following is a question of LOAD utility.
Question:
How does the DB2 enforce table check constraints for data added to
table with the LOAD utility?

DB2 V8.2 ICE Linux
An application is loading around 6 million rows in a table in database A
(Development environment).
The same application is taking ages to load the same table in database B

          I have a small doubt in replication.Previously i was working
on replication with the databases under the same instance.So it worked
fine.
         Now i'm facing a new problem which is like, now i want the