Kunal,
'checkpoint' is a plain top-level operator so you can, e.g.,
exec ('checkpoint');
even if it's not a legal part of a compound operator. Briefly specking,
if you can call "create procedure ..." or "create table ..." in some way
then you can call "checkpoint" as well.
It's not bad idea to "commit work" (or to "rollback work") immediately
before doing checkpoint in the middle of procedure. That's not a strict
requirement, because checkpoints do not interrupt transactions in
progress. I simply don't like something running in parallel with a very
special thing like a checkpoint, that's my personal paranoia :)
Best Regards,
Ivan Mikhailov,
OpenLink Software.
On Fri, 2008-02-15 at 12:42 -0800, Kunal Patel wrote:
> Hi,
>
> Is there a way to call the checkpoint command from a procedure?
>
> Regards,
> Kunal
