Hi All, Need help to write an SQL, requirement is as below.
db2 => select * from dealer
D_KEY       NAME
----------- ----------

Colleagues:
Take a query like
SELECT
    DISTINCT

I am a pretty new DB2 user(Old MSSQL user), and therefor i have a question  
to a query.
Usualy I can make stuff like (Silly example)
declare @hat int

We have a significant (and increasing) number of identical databases
spread over numerous servers (linux) and are finding it a pain making
table changes since we are currently issuing the alter command manually
against each db. We are looking for ways to simplify this process - one

I'm able to call a COBOL program directly using the iDB2 .NET native
provider and run it if I hard code the parameters.
However, I want to use InputOutput parameters to return values.
However, it does not seem that these get replaced by the values they are

DB2 v8.1 FP 11 on AIX 5.2.
A REORG of a table created in a 4KB-PAGESIZE tablespaces with
associated LONG data stored in a 16KB tablespace is failing with the
following error:

People,
if I have the following table table:
CREATE TABLE DATES_A (
    DATE_A        DATE     NOT NULL WITH DEFAULT CURRENT DATE,

is it possible to relate a Java SQL exception (for example: SQL Editor
- bad syntax in a user's sql statement)  to the corresponding db2 error
message in a java application?
Does it depend on the JDBC driver type?

    we are using DB2 v8.1 on Linux64 for a DW application. We have a
table with around 800 million records in it. For performance purpose we
created about 2 or 3 MQT's(summary tables) on the table with refresh
immediate option. But when developers come up with some changes on the

I know this subject has come up many times but I am not finding what I
am looking for after a couple days of searching.  I know some months
ago I saw an indirect solution for this but I cant seem to find it now
that I need it.

Does anybody know what is binary representation of integer datatype
fields written to archlogs on z/OS (OS/390) machines? Is it "Two's
complement", "One's complement", Sign-modulo or whatever?
I would analyze it for myself if someone would provide me with some

I was wondering if anyone knows why this error is occurring.  Every
once in a while I will get an sql -1024 (we are looking in to why this
occurs in the first place).  I automatically do a DB2 CONNECT and it
reconnects without a problem.  Occasionally, however, the reconnect

I got the SQL0293N error. someone can help me to solve this problem? My
db2 is version 7.1 on win2000 server.

Hello list,
Sorry to ask such a stupid question; I am obviously not looking at right
places, but what is the counterpart of set event monitor? There is no
get event monitor and no state column in db2 catalog tables. How do I

Can it be done?  If yes, how so?