RE: Survey for AS/400 Developers (ISERIES) DB2/400

Guys, there was a email in the body of the original note that wanted
comments.  I don't know if thier sub'd to m-l but folk should be
automatically cc'ing that person.

As I read this, it's telling me that SQL is the only way IBM wants people
to be able to access their data...I have a problem with that.

Don



On Fri, 27 Oct 2000, David Dunfield wrote:

> Native RPG access to DB2/400 is the issue. You will never convince me that a
> SQLRPGLE program is the way any RPG programmer would be the choice to access
> DB2.
> 
> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of DAsmussen@aol.com
> Sent: Friday, October 27, 2000 12:26 AM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Survey for AS/400 Developers (ISERIES) DB2/400
> 
> 
> David,
> 
> What's the problem here?  OPNQRYF not receiving the latest updates?  Good
> riddance to bad rubbish, I say.  SQL is _FAR_ more intuitive...
> 
> JMHO,
> 
> Dean Asmussen
> Enterprise Systems Consulting, Inc.
> Fuquay-Varina, NC  USA
> E-mail:  DAsmussen@aol.com
> 
> "Everywhere is walking distance if you have the time." -- Steven Wright
> 
> In a message dated 10/26/00 3:15:11 PM Eastern Daylight Time,
> ddunfie@net-link.net writes:
> 
> > I received this e-mail from IBM today. It raises some real concerns for
> the
> >  future if the Iseries.
> >
> >  IBM values your input on the design and direction of DB2 UDB for
> >  AS/400.
> >
> >  For some time now, SQL has been the strategic interface for the
> >  industry and the AS/400 database, DB2 UDB for AS/400. As such,
> >  IBM has focused the database investment on SQL and has made
> >  some new database  functionality  (e.g.,  BLOBs, ROUND &
> >  DAYOFWEEK scalar functions,  Derived Tables, etc)  available
> >  only on SQL interfaces.   As a result, non-SQL interfaces such as
> >  OPNQRYF were not enhanced to access these new database features.
> >  Although it's not a common practice,  native opens (OPNQRYF,
> >  OPNDBF, high-level language opens) currently can reference most
> >  SQL Views  (an SQL View is just a logical file),  so it is possible to
> >  create an SQL View that uses some of the newer database
> >  functionality and then have native open reference that SQL View to
> >  access these newer features.
> +---
> | 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
> +---
> 

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