Re: Changing database to SQL from DDS -- MIDRANGE-L

Just my 2 cents,

There's also nothing that says that you cannot use SQL to add constraints
to files that are created with DDS. OpsNav makes this quite painless. If
you have the tools, why not use the ones that are best suited for the job.

I don't know your application so it is hard to make an informed statement
on your performance, but, we use about 25% SQL and 75% native I/O. I have
not seen a marked performance improvement using SQL. We use SQL when we
need more flexible data access.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \



|--------+------------------------------------>
|        |          Vern Hamberg              |
|        |          <vhamberg@centerfieldtechn|
|        |          ology.com>                |
|        |          Sent by:                  |
|        |          midrange-l-bounces@midrang|
|        |          e.com                     |
|        |                                    |
|        |                                    |
|        |          01/08/2003 04:18 PM       |
|        |          Please respond to Midrange|
|        |          Systems Technical         |
|        |          Discussion                |
|        |                                    |
|--------+------------------------------------>
  
>-----------------------------------------------------------------------------------------------------------|
  |                                                                             
                              |
  |       To:     Midrange Systems Technical Discussion 
<midrange-l@midrange.com>                             |
  |       cc:                                                                   
                              |
  |       Subject:     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
>_______________________________________________


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