Hi...

I have a question.
I am to replicate data from a satellite database which is in MySQL to a Core Database which is in DB2.
The datatypes of MySQL and DB2 differ, like datetime in MYSQL is TimeStamp in DB2.
There is a type "Text" in MySQL, What corresponding type is there in DB2. I found one like CLOB but it has certain limitations like "it cannot be used in queries using the 'starts with' or 'like' keywords.."

Is there a way out??

Would appreciate an early response.

Thanx
Ritika