Re: Changing database to SQL from DDS

Thanks, Tom, I needed this. ;-)

I also agree with your other post, that once files are created, by whichever method, they can, for the most part, be processed by whichever method. E.g., foreign/parent key relationships created with SQL will be enforced when records are added/changed/deleted with an RPG program.

Regards

Vern

At 12:50 PM 1/8/2003 -0800, you wrote:

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
_______________________________________________