Kunal Patel wrote:
  Is there a way to call the checkpoint command from a procedure?

You could, for example, do:

  create procedure proc_cp()
  {
    exec('checkpoint');
  }
  ;

  proc_cp();

I'm curious to know why you would want to do this?

see: <http://docs.openlinksw.com/virtuoso/fn_exec.html> for more on exec in general, e.g. using the result of the query and checking the sqlstate, etc...

Rob.

Reply via email to