×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Rick, is this in an exploratory stage, or is the decision made? Just so we
don't discuss needlessly the "whether" matter.
ERWin, and similar products (Popkin makes one, Sybase has one, IIRC) can
reverse engineer AS/400 databases into SQL DDL statements. Some can also
generate DDS from iSeries tables. OpsNav, now, has a "Generate SQL..."
function, but keyed logicals only get a CREATE VIEW generated, not a CREATE
INDEX. At least it put in a comment that it ignored the key field
specifications. There's also Surveyor, by Linoma. But, generally, you can
get a script to recreate your entire set of tables and views and indexes
with some of these tools. That's a nice feature of the SQL side of things.
Will you continue as an RPG shop? There's no need (except for join
logicals, and some other special functions) to redesign present files. SQL
will use them as easily as those generated with SQL DDL (data definition
language) statements.
I think there is little to be gained by going to SQL, just to go to SQL.
DDS has all the functionality (and more). Do you have a lot of SQL
expertise now? Are you transferring data to/from Oracle with SQL, or other
means (FTP, etc.)?
OTOH, RPG can use SQL tables and views, but not indexes, IIRC, for native
IO. This precludes the benefits of keyed processing in RPG. (I could be off
here.)
Please ask more, if it seems useful to do so.
HTH
Vern
At 02:59 PM 1/7/2003 -0600, you wrote:
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.
TIA,
Rick Chevalier
Sr. Programmer Analyst
(817) 525-7178
rick.chevalier@americredit.com
midrange.com
