WAIT

Description

The stored procedure WAIT waits the specified time (milliseconds)

Syntax

WAIT (
    timeinmillis : long
)

It does not return any row; it only waits for the specified time.

Privileges Required

No privileges are required to execute this procedure.

Examples

Example 1

-- Waiting one minute
CALL WAIT(60000);

Example 2

-- 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.