SQL Server Queries to DB2 compatible

[buntyindia]

Hi All,

I have a application that is using SQL Server Database.
But now we have to switch its database to DB2 as per requirement.

Please tell me how can I make SQL Server queries compatible to DB2?
as some of command are not supported by DB2 or syntax is different...

Help..

[ck9663]

I doubt if you can make it compatible. As you said they have different syntax. Which means you can not have a query that can run on both. If your converting to a different DB, that means you have to re-write your queries.

-- CK