I am running a web app and whenever I try to start it it give me the
following error:
java.sql.SQLException: [SQL0199] Keyword ORDER not expected. Valid
tokens: , FROM INTO.

These particular servers do not have the DAS enabled, so I have to
document the contents of the instances, initially "instance X contains
n databases (A, B, C< ....)")
I can get get list of isntances on a server by using the db2ilist

I downloaded the DB2 runtime client, but the Client Base support and
the TCP protocol do not install. I re-run the setup select them to run
from disk, and they still show as not installed. What am I missing?
Running Windows XP SP1

I used google, but I found nothing.
I have got smiple code:
#include <sql.h>
int main()

Hi, I've a question about DB2 and jdbc:
Which port use Jdbc for communicate with DB2?
This is the ErrorCode with the explanation by http://snipurl.com/cd02
CLI0616E    Error opening socket.

I have  dates stored as 20040904(yyyymmdd numeric) in DB2 database. I
want to get the difference between two dates. I also have the same
database in SQL Server database and I am using the following SQL to do
the arithmetic in the where clause.

Hi! I really need help to fix this prob. The main problem is that I cant
use the universe (Ver: 10.0.13) remote connection via TCP layer. There
is no port available to connect my self whit an ODBC. System is running
Fedora core 3 whit an AMD64 3500+ - 4Gb - SATA. Locally it work ...

Folks,
I'm installing DB2 on a brand new IBM xSeries box, which has Intel Xeon
processors with EM64T extensions.
We are using SuSE Linux Enterprise Server 9, and when installed the HOSTTYPE

Is it possible to rollback a transaction which is started by a
JavaServlet with db2cmd manually?
Thanks in advance.
Jörg Lange

In dynamic SQL I'm inserting a row to a table with an IDENTITY column.
How can I retrieve the generated identity value?
The statement "VALUES IDENTITY_VAL_LOCAL()" returns the following error
when I try to PREPARE it:

I have no experience with DB2 as such, but I've been tasked with configuring
backup of a server running DB2 v8 on Windows Server 2003. I do have some
experience with backups in general though. The backup software I'll be using
is Backup Exec 10, but Backup Exec doesn't have a ...

How do I code a SQL SELECT statement so that always only this record is retrieved
which matches a certain criteria AND has the lowest ID (= value in key field aaa)?
It must me something like
SELECT * FROM .... WHERE somefield='somevalue' AND aaa=lowestkey(column(aaa))

Is there any way to reduce the size of my db2 log files? My sqlogdir is
69gb with hundreds of log files, more than the size of the database
itself, and I am running out of hard disk space. I am thinking one way
would be to create a new database and then export the tables one by one

I'm currently coping with a problem on which I hope you could shed some
light.
Imagine the following:
I have table in DB2 8.1 (.5) which is defined as:

HI, I HOPE SOMEBODY CAN HELP ME WITH THIS, I´M TRYING TO CREATE A
TRIGGER WITH A SCRIPT, BUT WEND I RUN IT ALWAYS SEND ME A ERROR
"SQL0104N  Se ha encontrado una señal imprevista
"END-OF-STATEMENT" a continuación de "END".  Entre las señales