MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 1999

Re[2]: Semi-Optimistic



fixed


     So, if SQL is the preferred method, then when is SQL/400 going to 
     become a "free" licensed program? It just doesn't make sense to me 
     that:
     1) If SQL is a fully supported feature of OS400 (already built in), 
     and
     2) IBM increases value of DB2 and SQL by optimizing and enhancing 
     its technology, then
     3) We who develop OS400 application can't use any of this unless we 
     shell out $$$ to access features built-in to OS400 (which we've 
     already paid for).
     
     eric.delong@pmsi-services.com


______________________________ Reply Separator _________________________________
Subject: Re: Semi-Optimistic 
Author:  <MIDRANGE-L@midrange.com > at INET_WACO
Date:    2/19/99 1:14 PM


Pete Massiello wrote:

>     Why isnt this stuff set up to be used with DDS, when almost the entire
> existing AS/400 population uses DDS, and not SQL to define their files.
>

It *is* IBM's stated direction to continue to add funtionality through the SQL
interface and not necessarily back through the DDS interface.

Is this a good choice?  Well, if you work on *any* other database, you use SQL 
DDL
statements to create the tables, views and indexes.  Why not have the same 
common
interface?

Is it good to leave it out of DDS?  IMHO, no, but at the same time, I am not 
*too*
upset to see IBM pushing people towards the SQL interface.  It simplifies *my* 
job.

You know, just because you did it that way in the past...  ;-)

b.

>     Just my opinion.
>
>         Pete
>
> Danny.Jahr@lawson.com wrote:
>
> > I also found this interesting tidbit at:
> >
> > http://www.zdnet.com/pcweek/stories/news/0,4153,388831,00.html
> >
> > "With the optimizer, a query that took 2 hours now runs in 35 seconds,
> >                  according to officials."
> >
> > Sounds like they are selling us the Brooklyn bridge.  The optimizer works
> > using existing
> > statistical data and the SQL statement. Does the product rewrite a user
> > query full of select/omits?
> >
> > Dan Jahr
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator: 
david@midrange.com
> > +---
>
> --
> Pete Massiello
> OS Solutions International
> Phone: (203)-744-7854  Ext 11.
> http://www.os-solutions.com
> mailto:pmassiello@os-solutions.com
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---



--
===========================================================
R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Administrator

-- The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact