I am using Q Replication, I need to set to logging to capture changes on a
table but the table has more than 18 characters for the name, I looked at
the docs, it mentioned that table names with more than 18 characters are
allowed in DB2 V8 but when you turn on logging, it will not ...

We run DB2 UDB v8.1 on Windows. How do I find the list of all users that
have the following privileges:
1. User Data Maintenance
2. System Tabale Maintenance

If I start an INSERT ... the Result is an "x Row(s) affected" on the
console.
Is it possible to print out my own messages (e.g. to output the value
of a variable)?

This is probably the wrong forum for this, but I thought it might start
some discussion.
The INSERT statement, in its current form, has problems being formatted
so a human reader can follow it. In particular, for a table with many

Platform is DB2/NT 7.2.9
The table was created like this:
CREATE TABLE MYTEST (
 MYTESTOID bigint not null primary key,

My question is: How to concat values from several lines (the same
column) to only one value. For example:
 We have table SGMENT with one column: NAME (varchar2(50)). We would
like to have as a query result the concatenation of names. I mean, for

Since DB2 V8 command center always displays the full error message. Not
only the SQL error number and some short specific information, but the
whole bunch of additional stuff which you find in the documentation.
Is there a possibility to deactivate those elaborate error messages? I

I'm trying to query our JD/Edwards database via a iDB2DataAdapter. I
get the correct number of rows after the fill command but the items in
the dataset are converted to system.array.
The database has CCSID = 65535. This is default by JD/Edwards, so we

Have anyone tried to download UDB 8.2 Linux x86-64 Personal Developer
Edition? As for me the page says the file should be 400MB, for HTTP
method server returns ~280Mb (and tar says unexpected EOF) and Director
does not work.

I was trying to do the following:
update db cfg for oltprd using VENDOROPT "'-SErvername=aixstl20'"
update db cfg for oltprd using LOGARCHMETH1 TSM
update db cfg for oltprd using logarchopt1 "'-SErvername=aixstl20'"

I'm driving Weblogic 8.1.3 on WinTel.
DB2 8.1.4 on Sun64.
I'm using Weblogic DB2's Type 2 driver, which has been very
reliable - so far.

I have lots of dates in my schema, almost none of which may be entered
as future dates. The best I could come up with is the following two
triggers, repeated for each table.column which is a date. Anyone have a
better idea? I'm just adding triggers to my toolbox and will ...

It isn't in the places I looked in the SQL Reference, but examination of
syscat.triggers yields 18, if I read it correctly. Is 18 correct?

In my Java-application I create an PreparedStatement like this:
PreparedStatement v_stmt = dbcon.prepareStatement("SELECT * FROM
mytable WHERE UPPER(userID) LIKE UPPER(?)");
v_stmt.setString(1, "me");

We are in the process of evaluating the IBM encryption tool in db2 v8
on z/os. Does anyone know whether the editproc used in the IBM
encryption tool inhibits the use of index while running selects? We
have large tables - over a few 100 millions.