"That is exactly it! I don't know how many times I've either duplicated subselects in both the select and where clause, or I've created common table expressions just to reduce the duplication. This might not change my life, but its like getting that big storage barn I've always wanted."
Darren,
I've been working on an article showing a bunch of different things which you can do in sub-selects and lateral correlation. Statements like that and the the one Vern made earlier "These new SQL services are fantastic. From working with journal entries to object information to group PTF status to ??? and have the results available directly with SQL statements - well, it's marvelous." shows the excitement in our community embracing the latest DB2 offerings and makes me want to finish my article.
Jim
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
