Roy Boxwell

Looks like a great case for an MQT??? Create an MQT using your
query (But
remove the FETCH FIRST 20 ROWS ONLY clause) this will then be your
"base"
table that you can then
simply query using SQL and make it pretty using QMF.
To do your SQL you would then simply write

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA
*
* Your only source for independent, unbiased, and trusted DB2
information. *
_____________________________________________________________________http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this
economy?
Mentoring is a proven, economical, way to train the next generation
of DB2 Users!
_____________________________________________________________________

This transmission is confidential and must not be used or disclosed
by anyone other than the intended recipient. Neither Tata Steel
Europe Limited nor any of its subsidiaries can accept any
responsibility for any use or misuse of the transmission by
anyone.

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA
*
* Your only source for independent, unbiased, and trusted DB2
information. *
_____________________________________________________________________http://www.IDUG.org/mentor
How can you expand your staff or do succession planning in this
economy?
Mentoring is a proven, economical, way to train the next generation
of DB2 Users!
_____________________________________________________________________