The stored procedure
WAIT waits the specified time (milliseconds)
WAIT ( timeinmillis : long )
It does not return any row; it only waits for the specified time.
No privileges are required to execute this procedure.
-- Waiting one minute CALL WAIT(60000);
-- Waiting 10 seconds SELECT timeinmillis FROM WAIT() WHERE timeinmillis = 10000;
These two examples show two different ways of invoking WAIT: one with SELECT and another with CALL. Both ways are equivalent. The difference is that if you invoke WAIT from a SELECT statement, you can combine the result with another view although usually, you will not need to do this. The page Use of Stored Procedures provides more details about how to invoke the stored procedures of Denodo.