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.