View Full Version : Links to SQL Development
01-01-1995, 02:00 AM
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
08-21-2000, 06:35 AM
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
08-21-2000, 08:27 AM
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
08-21-2000, 01:36 PM
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.
08-22-2000, 01:34 AM
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
Powered by vBulletin® Version 4.1.5 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.