Challenge wrote:

> Hi,
>
> I have some questions about DB2 range parition and I cannot find the
> answer from the document.
>
> 1. Can I name the partition name for every partition in a range
> partition? For example, p2008jan for data of Jan, 2008?

Different question back: Is this an existing, home-grown application? If
not, is there a particular reason for not applying proper data modeling and
denormalization of the data?

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany