ODBC connector

[tommy]

I want to transfer data from probsummary to a database on DB2.

As a test I have created a database on DB2 with following fields:

number          number
open_time      timestamp
update_time   timestamp
close_time      timestamp

The map looks like shown in the images.

On the first run everything is ok. But In the next cycle if a problem has been updated I get this error:

2002/06/28 12:41:01.000	0	1	ODBC error: [IBM][CLI Driver][DB2/NT] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because they would produce duplicate rows for a table with a primary key, unique constraint, or unique index.  SQLSTATE=23505\r\n SQLSTate: 23505
2002/06/28 12:41:01.000	0	4	A document in the group has been rejected: Recommitting documents one by one...
2002/06/28 12:41:01.000	0	1	ODBC error: [IBM][CLI Driver][DB2/NT] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because they would produce duplicate rows for a table with a primary key, unique constraint, or unique index.  SQLSTATE=23505\r\n SQLSTate: 23505
2002/06/28 12:41:01.000	1	4	Documents recommitted.

[tommy]

It seems that reconciliation key does not work with a number field!

If I change the number field in the DB2 database to 2 text field and converts the mnumber from SC to 2 string like this

"PM" & str([number])

then it works