Friends,
Say I have the following UDF:
CREATE FUNCTION GET_MONTH(P_DATE DATE)
   RETURNS INTEGER

Our product works fine on all 7.x and 8.x DB2 versions. But stops to
work on DB2 v9.1.
The main problem is - duplicate primary key (sqlcode=-803) happens when
inserting records in QUEUE table.

I'm using procedure ADMIN_CMD to export/import tables into IXF files.
Is there a way to tell what codepage EXPORT/IMPORT should use?
Best regards,
       Kovi

Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(65)) => A
VALUES(CHR(129)) => null, but according to www.asciitable.com should be u

Is Two phase commit allowed in DB2? We need to update a local tables
and few federated tables in a single Unit of Work. Is it possible to do
?
Regards,

hi, we are using db2 v8.2 EE on windows, with jcc driver. try to create
a join view, after that i check the syscat.columns table, for those
decimal field  use COALESCE method, all the length become 11 instead of
the actual length of the field inside table, can anyone explain this to

In testing our app, we connected and disconnected like 1000 times and
noticed a 5 meg memory leak.  The sequence of connecting and disconnecting
is as follows:
1.  OdbcSQLAllocHandle

          I would like to know about the following db cfg parameters
in detail (i.e) what is the main difference b/w all the parameters,and
basing upon what criteria do we update them?I want the answers in some
real time point of view so that it would be helpful alot.