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

["Stone, Brad V (TC)" <bvstone@xxxxxxxxxxxxxx>]

I like opnqryf, but since I've been doing a LOT of e-RPG, I'm finding
SQLRPGLE programs much easier since I can much more easily build a dynamic
SQL statment than a dynamic OPNQYRF statement.

Brad

> -----Original Message-----
> From: rob@dekko.com [mailto:rob@dekko.com]
> Sent: Friday, October 27, 2000 9:36 AM
> To: MIDRANGE-L@midrange.com
> Subject: RE: Survey for AS/400 Developers (ISERIES) DB2/400
> 
> 
> 
> Gee, I code RPG, I've used SQL in my RPG.  I didn't have a 
> gun pointed to
> my head telling me to do so.
> 
> Any others?
> 
> 
> Rob Berendt
> 
> ==================
> Remember the Cole!
> 
> 
>                                                               
>                                                            
>                     "David Dunfield"                          
>                                                            
>                     <ddunfie@net-link.n        To:     
> <MIDRANGE-L@midrange.com>                                         
>                     et>                        cc:            
>                                                            
>                     Sent by:                   Subject:     
> RE: Survey for AS/400 Developers (ISERIES) DB2/400           
>                     owner-midrange-l@mi                       
>                                                            
>                     drange.com                                
>                                                            
>                                                               
>                                                            
>                                                               
>                                                            
>                     10/27/00 06:33 AM                         
>                                                            
>                     Please respond to                         
>                                                            
>                     MIDRANGE-L                                
>                                                            
>                                                               
>                                                            
>                                                               
>                                                            
> 
> 
> 
> 
> 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
> +---
> 
+---
| 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
+---