From: Ivan M. <imi...@op...> - 2008-02-17 19:00:51
|
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 |