Hi,
Please don't throw your hands up immediately and quote me "this is not
supported" etc ....
I have a "temporary need" to move our DEVELOPMENT databases off our

The error I get is SQL0206N  "TEAM" is not valid in the context where
it is used.  SQLSTATE=42703 and the problem lies with the group by team
line.  When I remove the group by team statement db2 says that I have a
column function without a group by statement so I need it.

I would like, without writing a procedure which require the configuration of
an additionnal C-compiler and which is not portable (I am wring ? java
application targeted on DB2). And I would like to create a kind of alias of
a sequence. The goal is to have a user access a sequence ...

Hallo all,
I'm quite new to SQL and I have a problem updating some fields in a table,
maybe some of you in this forum can help me!
This SELECT statement returns the records that I need to update:

I'm getting a deadlock when I have two clients running the following statement.
DELETE FROM intermediate.file_os_details WHERE file_uid = ? AND obj_uid
There is a compound index on file_uid / obj_uid.
The isolation level is UR and I have set DB2_RR_TO_RS=YES.

I am trying to find out if there is a way to limit the number of rows
returned when a cursor is opened.  I am using DB2 version 7 on z/OS.  The
SELECT statement in my DECLARE CURSOR statement could potentially return
400,000+ rows, but I really only want the first 15 records found.  ...

Is it at all possible (on DB2 V7.2, AIX) to restore a single table from a
full table backup?
The RESTORE DB command doesn't have this functionality - at least not
according to the DB2 manuals.