Rick Hillegas <[email protected]> writes:
> 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.
Or perhaps simpler: a VALUES statement.
Just replace this
FROM SYSIBM.SYSDUMMY1 WHERE 1=0 WITH UR
with this
FROM (VALUES 1) V WHERE 1=0
--
Knut Anders
