Re: Semi-Optimistic

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

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