On 5/17/11 9:10 AM, drv wrote:
select * from new com.ibm.db2j.GaianTable('LT0') T where misc is not null
Hi David,
You may want to change Gaian to use Table Functions instead of VTIs.
Table Functions are the supported ANSI/ISO analog of VTIs. I do not see
this error when I select from a Table Function instead of a VTI. Table
Functions do not rely on the special backdoor which was put into Derby
to support VTIs from the com.ibm.db2j package. I do not know if anyone
is supporting that backdoor these days.
Regards,
-Rick
