"Bergquist, Brett" <bbergqu...@canoga.com> writes:

> I am implementing a poor man's data partitioning with data being
> inserted into different tables depending on the week of the year.  I
> want to bring these tables back together as single virtual unified
> table that can be queried up only, no inserts or updates required.
>
> I am looking at maybe using a Restricted Derby Style Table Function to
> do so because I have some optimization mechanisms that I would like to
> employ in the implementation.  Can a Derby Style Table uses the nested
> connection?

I believe the asnwer is "yes".

Dag

>
> Connection conn = DriverManager.getConnection("jdbc:default:connection");

Reply via email to