Thank you very much for the info, Ann.

Greetings.

Walter.

On Tue, Jul 30, 2013 at 4:06 PM, Ann Harrison <aharrison@...>wrote:

> **
>
>
>
> W O <sistemas2000profesional@...> wrote:
>
> > If the tables have always the same name you don't need the EXECUTE
> STATEMENT
> >
> >>
> >>
> >> I found a simple solution:
> >>
> >> EXECUTE STATEMENT 'insert into A select * from B';
> >>
>
> The execute statement form works better if the format of the tables is
> volatile. You avoid the "object in use" error if the procedure has been
> compiled.
>
> Good luck,
>
> Ann
>
>
>


[Non-text portions of this message have been removed]