- 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 might not be exactly the same as the specified wait time.
The reported wait time might not be exact.
SYSTEM$WAIT checks periodically for cancellation. If a user cancels a query while it is waiting, there might 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 | -------------------+