Re: Changing database to SQL from DDS

I've been working in a system that uses both DDS and SQL for a few years now. 
Now, I'm migrating the DB2 to another server. It's been cake, so far. Major 
hurdles to overcome have been: (1) reconciling key structures and indices for 
performance; (2) handling cursors for what used to be simple processes in 
RPG. Good luck.

- Hank Heath

In a message dated 1/7/2003 5:38:45 PM Eastern Standard Time, 
Rick.Chevalier@americredit.com writes:


> My company is looking at changing our database to be SQL based instead of
> DDS.  I would like to know of anyone's experience converting files to SQL
> from DDS along with pros and cons of having your database developed in SQL.
> We are primarily a RPG shop with some web development.  There is also some
> data transfer between Oracle databases and our iSeries.
> 
> The posts I found in the archives were several years old and seemed to get
> bogged down in finer points of how to implement.  I'm looking for a broad
> view of the issue right now.