Re: Changing database to SQL from DDS

Rob wrote . . .
>> The problem to that is recreating the databases.  Granted CHGPF is
nice 
>> because you don't lose the constraints.  

By why would you have to recreate the database?  There are over 2000
tables in the production libraries on my system.  The magnitude of the
job to build scripts for each of those tables is mind-boggling.  There
is also no reason you can't use a SQL script instead of DDS for new
tables, and even if you have to modify an existing table.

There can certainly be huge improvements in performance from putting RI
constraints instead of coding RI in RPG, and by taking advantages of the
improved performance of SQL for long-running batch processes and
mass-updates.  But those can be done without recreating any existing
tables.

Am I missing something?

>>> rob@dekko.com 01/08/03 01:47PM >>>
The problem to that is recreating the databases.  Granted CHGPF is nice

because you don't lose the constraints.  But to create one from scratch

you have to create a MAKE tool to rebuild a file, if you use DDS.  In
SQL, 
this can all be contained in the script.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Tom Jedrzejewicz @ San Pedro" <TJedrzejewicz
Sent by: midrange-l-bounces@midrange.com 
01/08/2003 03:50 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     <midrange-l@midrange.com>
        cc: 
        Fax to: 
        Subject:        Re: Changing database to SQL from DDS


I have been taking "SQL" to mean SQL commands to define and manage the
table, and embedded SQL in a HLL for data manipulation.

I have been taking "DDS" to mean the native (original) methods to
manipulate tables -- DDS to define, OS commands to manage existence
and
attributes, and standard HLL I/O operations for data manipulation.

With these definitions, there is validity to Vern's contention, as
"DDS" includes the various OS commands to manage triggers, contraints,
journaling, etc. 

>>> rob@dekko.com 01/08/03 10:46AM >>>
Vern,

"DDS has all the functionality (and more)."  I don't think so.  What
are 
the DDS keywords for referential (and other) constraints?

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 
_______________________________________________
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.

THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY
TO 
WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, 
CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW.  If the 
reader of this message is not the intended recipient, or the employee
or 
agent responsible for delivering the message to the intended recipient,

you are hereby notified that any dissemination, distribution, copying,

downloading, storing or forwarding of this communication is prohibited.
If 
you have received this communication in error, please notify us 
immediately via email and delete the message from your computer files 
and/or data base.  Thank you.
_______________________________________________
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.


_______________________________________________
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.

THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH 
IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL 
AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW.  If the reader of this message 
is not the intended recipient, or the employee or agent responsible for 
delivering the message to the intended recipient, you are hereby notified that 
any dissemination, distribution, copying, downloading, storing or forwarding of 
this communication is prohibited.  If you have received this communication in 
error, please notify us immediately via email and delete the message from your 
computer files and/or data base.  Thank you.