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
...
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
a) How to check the log and where is it located ?
b) How do I troubleshoot ?
...