Re: Changing database to SQL from DDS

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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