db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: is it possible to call language sql/execute/AlterTableConstantAction from a system procedure?
Date Sat, 25 Feb 2006 01:59:24 GMT
Hi Mike,

Mike Matrigali wrote:

> are 3 options:
> 1) copy the code to the system procedure
> 2) use the same method as offline compress, ie. add some internal
>    syntax so that the whole setup is just done by the parser.
> 3) somehow call the alter statement node directly from "around"
>    the parser.  I have no idea if this is possible, or how hard.

I would vote for option 2) here... since we already have <ALTER> ....
<COMPRESS> [ <SEQUENTIAL>] production in the parser. Would it be
sufficient to add another token, like [ <OFFLINE> ] and switch the
implementation at execution time? If so, much cleaner than 1) or 3), in
my opinion.


> Any opinions on how to get the system procedure inplace compress
> to share the alter table execution code?

View raw message