Dinesh Ramakrishnan wrote:Can I know whats the issue with direct SQL's. We use direct SQL's mostly for read-only queries and I thought could modify the queries if for any Oracle specific keywords
This is the problem - that Oracle specific syntax creeps into hand coded queries. Like Oracle's rownum, vs db2's fetch first. Depending how many queries you have, this could be a lot of work to change.