Re: [jira] Commented: (DERBY-716) Re-enable VTIs

[Rick Hillegas]

Dag H. Wanvik wrote:
"A B (JIRA)" <[EMAIL PROTECTED]> 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".

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