Suspends the session for a given period of time

Database
Enthusiast

Suspends the session for a given period of time

Hi all,
how can I suspend the session for given period of time.
In oracle we use dbms_lock.sleep.
how can i achieve this in teradata.
Plz help me.

Thanks in advance.
1 REPLY
Senior Apprentice

Re: Suspends the session for a given period of time

Hi Monika,
AFAIK that feature is available only in BTEQ:
.HANG n;
where n is the number of seconds.

Dieter