udb

Datatype conversion in IBM DB2

I'm writing a query to do some stuff. But its not working the way I want it to: select CORR_ID from TABLE1 where CORR_ID not in (select id from TABLE2) The problem is, TABLE2.id is a long, while TABLE1.CORR_ID is a string. So how can I make it work? PS: I'm using IBM UDB. ...

How do I create control tables in DB2 UDB for setting up new replication

How do I create control tables in DB2 UDB for setting up new replication ...

Oracle Migration Workbench

Does anybody know anything about using Migration Workbench to migrate db2 database to oracle 10G? I am getting a strange SQL1402N error when I try to get source capture. ...

How to troubleshoot UDB replication if the subscription set status = -1

How to troubleshoot UDB replication if the subscription set status = -1 a) How to check the log and where is it located ? b) How do I troubleshoot ? ...