db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-716) Re-enable VTIs
Date Wed, 25 Apr 2007 23:17:59 GMT
Dag H. Wanvik wrote:
> "A B (JIRA)" <jira@apache.org> writes:
>> Or as an alternate example, Derby currently supports the following:
>>    ij> create table st as select * from
>>           table (syscs_diag.space_table('T1')) s with no data;
> Is this form documented anywhere? I can see it in the grammar, but I
> can't find it anywhere in the docs. Omission?
> Thanks, 
> Dag

Hi Dag,

This syntax does not seem to be documented where you'd expect it, that 
is, in the Reference Manual section on the FROM clause. However, an 
example of this syntax appears in the Reference Manual section titled 
"SYSCS_DIAG diagnostic tables and functions".

>>    ij> insert into st select * from table (syscs_diag.space_table('T1')) s;

View raw message