Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; charset=us-ascii
Date: Sat, 25 Apr 2009 13:25:03 +0200
From: Knut Anders Hatlen <Knut.Hatlen@Sun.COM>
Subject: Re: SYSIBM schema
In-reply-to: <49F1DE2F.1050808@sun.com>
Sender: Knut.Hatlen@Sun.COM
To: derby-dev@db.apache.org
Message-id: <x6vdotq8kw.fsf@Sun.COM>
References: <49F1C120.2060201@sun.com> <49F1D52A.9020906@sbcglobal.net>
 <49F1DE2F.1050808@sun.com>
User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.0.90 (usg-unix-v)

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