Assuming that standard DB2 calls were made in the application, what risks do we face in porting?
Remember, while both DB2 and Oracle offer "100% ANSI-compliant" SQL, they have a vested interest in making their SQL better than the competition and they both offer non-ANSI features. An excellent example is the Oracle "decode" statement, an extremely useful features not found in DB2 SQL.
I would recommend extracting all SQL from the DB2 application and running it against the Oracle schema. Any syntax errors will point to any troublesome SQL.
Dig Deeper on Oracle and SQL
Related Q&A from Don Burleson
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.