Hi team, We have DB2 7.2 on Win2000 Mechine and I have DB2 replication
going between 2 Servers, when i look at the IBMSNAP_UOW table, i see an
Update Conflict, how can i find on which table the Conflict Occured.
Thanks

FWIW I finally figured out how to get sql-db2 mode to work under xemacs
without having it insert a blank line between every line of output.  Here
are the relevant lines from init.el:
(setq auto-mode-alist (cons '("\\.sql$" . sql-mode) auto-mode-alist))

We're currently using udb 7.2 on OS/2 and thinking about moving on to
8.1/8.2 on Windows.  In presenting the benefits of such a move I have
been unable to find out if the APIs available to C in 7.2/7.2 are
available in C# in 8.1/8.2.  With udb 8.2 can I back up and restore the

We have a VB6 application using ADO version 2.5 and I am receiving a
"[IBM][CLI Driver] CLI0109E  String data right truncation.
SQLSTATE=22001" error when I execute the rs.UpdateBatch method.  I have
determined that the error is caused by an extended ascii character 164

How do we move data from ORACLE COLUMNS like LONG RAW and RAW to DB2
BLOB and VARCHAR for BIT DATA?
WHICH IS THE BEST WAY TO DO THIS DATA TRANSFER?

... got: win2K, v8.1.6
login to win2K is to the network: user; bob13, domain; foo
it's a win2K domain.
i then login to my local db as db2admin.  LIST APPLICATIONS

What is the equivalent of ORACLE LAG FUNCTION in DB2 on Z/OS and UDB on
LUW??
LAG FUNCTION RETURNS THE PREVIOUS ROW.
select id, createdate, name old_name, lag(name) over(partition by id

We are having DB2-V7.2 DB on AIX 5.2 machine. Recently we upgraded our
system to fixpack 13 and activated activate AIX asynchronous IO
function.
Our DB is going to crash recovery with this error 0xFFFFF707.

You wrote the pleural of "schema" as "schemata."
My heart is warmed.
Americans write that as "schemas," since they have no concept of the
history of either their language nor their own culture.

Does anyone know what the limit is on the number of items you can
include inside of the "IN" function?
Thank you.
Carroll Rinehart

One of the fun tasks that is looking me in the face is generating a
list of potential stale accounts that access DB2. The systems are
running on OS authentication (login exists at the operating system
level).

Given these two tables in DB/2:
Date                Activity
------------------- --------
2005-01-02 00:00:00   1

 Greetings to All.
 I have encountered a problem while working on DB2 Governer.
I build my configuration file as below.(Just for practise)
 desc "Restrict the Unit of Work to be less then 1 minutes"

I can not create a stored procedure that calls another not yet created
stored procedure?
In MS SQL I get a warning that the calling procedure does not exist but the
new stored

What kind of difference does it make to update statistics
via 'REORGCHK UPDATE STATISTICS ON TABLE ALL' or by running
directly 'runstats on table xxx.yyy with distribution and detailed
indexes all" for all tables ?