Re: Changing database to SQL from DDS

[rob@xxxxxxxxx]

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.