db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: SYSIBM schema
Date Sat, 25 Apr 2009 11:25:03 GMT
Rick Hillegas <Richard.Hillegas@Sun.COM> 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

Mime
View raw message