Categories:

System Functions (System Control)

SYSTEM$WAIT

Waits for the specified amount of time before proceeding.

Note

With the 2021_07 bundle enabled in release 5.33, queries with a wait time greater than one hour that previously failed due to max compilation time reached, now succeed.

Syntax

SYSTEM$WAIT( amount [ , time_unit ] )

Arguments

Required:

amount

Number specifying the amount of time to wait as determined by time_unit.

Optional:

time_unit

Time unit for amount. Accepted values are DAYS, HOURS, MINUTES, SECONDS, MILLISECONDS, MICROSECONDS, NANOSECONDS. The unit should be in single quotes (see Examples below).

Default: SECONDS

Usage Notes

  • The function must be called as a system function.

  • Most systems do not have clocks that have nanosecond precision. As a result:

    • The actual wait time may not be exactly the same as the specified wait time.

    • The reported wait time may not be exact.

  • SYSTEM$WAIT checks periodically for cancellation. If a user cancels a query while it is waiting, there may be a delay between the time the query is cancelled and the time the cancellation takes effect.

Examples

CALL SYSTEM$WAIT(10);

-------------------+
    SYSTEM$WAIT    |
-------------------+
 waited 10 seconds |
-------------------+
CALL SYSTEM$WAIT(2, 'MINUTES');

-------------------+
    SYSTEM$WAIT    |
-------------------+
 waited 2 minutes  |
-------------------+