Re: Changing database to SQL from DDS

["Al Barsa" <barsa@xxxxxxxxxxxxxxxxxxx>]

Skip Marchessani does a talk at COMMON on the differences in defining a
database in SQL versus DDS, and I would say that all-in-all DDS does a
better job.  SQL is trendy.  One of the reasons that System/38 databases
were so solid was the existence of the DDS REF keyword, so that you could
create a field reference file, and make all of the fields refer to each
other.

Much to IBM fault, in recent releases, they have enhanced SQL databases,
but not DDS.  A prime example of this is EVIs (encoded vector indexes).

Regardless, unless you are doing something that can only be achieved in
SQL, the final databases you get are comparable.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com





                                                                                
                                                           
                      "Chevalier, Rick"                                         
                                                           
                      <Rick.Chevalier@ameri        To:       
"'midrange-l@midrange.com'" <midrange-l@midrange.com>                         
                      credit.com>                  cc:                          
                                                           
                      Sent by:                     Subject:  Changing database 
to SQL from DDS                                             
                      midrange-l-bounces@mi                                     
                                                           
                      drange.com                                                
                                                           
                                                                                
                                                           
                                                                                
                                                           
                      01/07/2003 03:59 PM                                       
                                                           
                      Please respond to                                         
                                                           
                      Midrange Systems                                          
                                                           
                      Technical Discussion                                      
                                                           
                                                                                
                                                           
                                                                                
                                                           




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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.