|
midrange.com
Nice to see a fellow compatriot here Dean. I feel the same way about
OPNQRYF.
What many people are missing is the fact that you can create views in SQL
which are not possible in DDS. But which may be used by traditional
methods. I recently posted a solution here about a view that someone
lamented that he could not do with DDS. I created the view (logical file
for those who don't know what a view is) with SQL and solved the gents
issue. So if there is a particular issue that you cannot address in a
traditional READ then either convert the READ into SQL, or create a view
which omits that particular element of the database.
But I will grant that I would like to see them attempt to have some of the
planned features accessible with a traditional READ, like DAYOFWEEK is
currently.
Rob Berendt
==================
Remember the Cole!
DAsmussen@aol.com
Sent by: To: MIDRANGE-L@midrange.com
owner-midrange-l@mi cc:
drange.com Subject: Re: Survey for
AS/400 Developers (ISERIES) DB2/400
10/26/00 11:26 PM
Please respond to
MIDRANGE-L
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
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
