Links to SQL Development

[Guest.Visitor]

Hi I am working on porting an Oracle database to DB2 on AS/400. Could you please let me know any usual links on the net for similar development. Could you also let me know of the problems/pitfalls to be aware of ?? Thanx in advance Arun

[Guest.Visitor]

There are a great many maintenance tasks that must be continually performed on Oracle DBs. Most of these tasks - such as space allocation, are not necessary with DB2/400. One of the pitfalls is trying to do yourself, what DB2/400 already does for you. Best of luck in your efforts, Dave

[Guest.Visitor]

Dave Thanx. We have jus started the coverting the tables, views etc., from Oracle to DB2 and I was interested if someone has done something similar to this and can point out to tips/techniques etc., arun

[Guest.Visitor]

IBM has some tips at http://www.as400.ibm.com/db2/db2tips.htm Is your database already defined in a datamodeling tool (ErWin, PowerDesigner, etc.)? We have had good success using PowerDesigner (once we got the hang of its "flexibility") to write AS/400 SQL. If you don't currently have the datamodel defined in a tool, you could, in theory, use a tool to reverse-engineer your Oracle datamodel and output an AS/400-compliant version.

[Guest.Visitor]

Hi We have the data model done using ERwin and have the scripts ready. I am interested in the porting issues that might come up when we are doing this. Thanx for the suggestion Regards arun