SQL Tips for DB2 LUW

with Tags: session

Featured Blog Entries

All posts

Suspending a session using a SLEEP procedure

Comments (3) Visits (19015)

In this post I want to introduce a handy procedure which can be used to suspend a session for a specified amount of time. A naive approach to wait is to simply execute a tight loop in a stored procedure such as this: --#SET TERMINATOR @ CREATE OR REPLACE PROCEDURE SLEEP(seconds INTEGER) BEGIN DECLARE end TIMESTAMP; SET end = CURRENT TIMESTAMP + seconds SECONDS; wait: LOOP IF CURRENT TIMESTAMP >= end THEN LEAVE wait; END IF; END LOOP wait; END @ --#SET TERMINATOR ; VALUES CURRENT TIMESTAMP; 1 --------------------------... [More]

Tags: wait suspend sleep session dbms_lock

Blogs

SQL Tips for DB2 LUW

About this blog

Links

Tags

Recent tweets

Suspending a session using a SLEEP procedure