Kathey Marsden wrote:
Rick Hillegas wrote:
Can someone shed some light on the purpose of the SYSIBM schema? It appears to hold a table called "SYSDUMMY1". What is this table used for?

The SYSIBM schema is used for the network server metadata queries. I see SYSDUMMY1 referenced in org.apache.derby.client.am.DatabaseMetaData.

Thanks Kathey. In the metadata queries it seems to be used to construct empty results sets of specific shapes. That is, its contents are not examined. Those usages could be replaced with a vacuous vti.

Thanks,
-Rick

Reply via email to