×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
SJL wrote:
3) Where would you find documentation for this in the System i online
reference books?
Elvis posted the link that helped me earlier. I looked at it many times
before but missed it. Footnote 53 says that a derived table is the
other name for a nested table expression.
You can read about them in the SQL Reference, near page 444 in the PDF
(printed page 420). Chapter 4 Queries, subselect, from-clause.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstsubselect.htm#subselect
In case you missed Evlis' post on the midrange-l list, I agree with his
assessment that it might be best to get a regular DB2 book. The SQL
Reference isn't as effective a learning tool as I thought.
--buck
This mailing list archive is Copyright 1997-2024 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.
midrange.com
