|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.