folgende Konstellation:
Ein z/OS-Rechner mit einer db2 v.8. Wenn ich mit User XY einen
SQL-Befehl direkt auf die Datenbank absetze [code]db2 select BEISPIEL
from TABELLE where SPALTE = 'TEXT' order by BEISPIEL[/code], dann

Dear Friends,
I want to show columns into rows. For example, I have a table,
TIMESHEET, with the following structure:
CREATE TABLE TIMESHEET

I would like to have the SPinner() to return the cursor (cc) to
SPouter, which returns it to caller (client).
My simple procedures is as follows:
CREATE PROCEDURE SPinner ()

I've been working in Oracle for many years, but am relatively new to
DB2.  My question is concering SQL PL.  Can you write to a flat file
from SQL PL?  For example, if you're writing a stored procedure to
purge records from a table, and you want to log those records to a

is it possible to programmatically update table statistics by
executing SQL-statements via Jdbc-driver?
My DB-application fills an initially empty table with a huge number of
rows and I try to speed-up the application by keeping the table-

I would like to be able to select the maximum (highest ) value for a
field, the 2nd highest, 3rd highest, etc.  Are there any other
functions that I might consider using with SQL?  MAX will only pick up
the highest and MIN the lowest value, but is there a way to pick up

I am seeing this behavior with IDENTITY COLUMN alter statements.
CREATE TABLE "SAMPLE   "."ID"  (
                 "KEYCOL" BIGINT NOT NULL GENERATED BY DEFAULT AS
IDENTITY (

I know what defining an index to ALLOW REVERSE SCANS does.
My question is, under what circumstances will the optimizer find a
reverse scan useful? In all cases that I can think of, the optimizer
should be able to traverse the index in the normal way.

I am getting a error sqlcode :  -911, sqlstate :  40001 error, i.e.
Deadlock error while trying to drop the procedure.
I had seen cases of getting deadlocks in a table but not in
procedures.

Does anyone have any recomendations for design of a database to be
used in a site such as mobile.de or funda.nl?
different product categories, with diferent attributes between them..
some shared some not.. and a variation of types.. multivalue, single

Environment: DB2 Personal Edition V8 on Windows XP.
If I, as Sysadm, grant a privilege to user Fred WITH GRANT OPTION and then
Fred in turn grants it to Barney, shouldn't both Fred AND Barney lose the
privilege if I revoke it from Fred?

I have a database that was created using DB2 V8.1 and I would like to
migrate it to V9.1 but I get a "log full" error.  I cannot connect to
the database to change the db parameters because the database has not
yet been migrated.  Do I need to revert back to V8.1 and change the

I have been testing compression for update operations.  Can anyone
tell me why I require more log for an update of a compressed table
than I do for the same table that is not compressed ?
I tried an update for the same number of rows for two copies of a

I'd like to count the number of transactions for each debit card and
month over a 3-month period.
But this query --
select DBT_CRD_DIM_NB,

Is there a guide, pamphlet, book, website, PDF or scroll somewhere
which states the SQLCODES which are valid for each SQL statement
(i.e., INSERT, CALL, FETCH, DECLARE CURSOR) in IBM DB2 (v7 or 8)?
I sometimes fall into the situation where someone has coded (or not) a