Re: Global tem****ary tables in Java DB -- Apache Derby

CJ <spambox1@[EMAIL PROTECTED]
> writes:

[snip]

> I have use SQL engines that use naming conventions such as
> "#tableName" and "##tableName." In the former, one pound character (#)
> the behavior is similar to the Derby declared global tem****ary table,
> the latter, the double pound character (##) creates a tem****ary table
> that is available to all within the scope of the schema.
>
> IMHO, something labeled as "global" that restricts access to the
> entity that created is not global in any definition I can imagine.

It may not seem reasonable, but that is what

ISO/IEC 9075-2:2003
Section 4.14.2 
9th paragraph

states. 

-- 
dt

Questions about Derby/Java DB? Please visit
http://db.apache.org/derby/derby_mail.html