【DB2】—— 存储过程自定义休眠

直接上代码

-- 核心操作
--/
CREATE OR REPLACE PROCEDURE TEST.SLEEP(seds INTEGER)
LANGUAGE SQL
BEGIN
	-- 休眠大师
	-- seds: 休眠时间 单位：秒(s)
	DECLARE end_time TIMESTAMP;
	SET end_time = CURRENT_TIMESTAMP + seds SECONDS;
	
	waiting:
		loop 
			if CURRENT_TIMESTAMP >= end_time 
				then leave waiting;
			end if;
		end loop;
	waiting;
END
/

-- 调用测试存过
--/
CREATE OR REPLACE PROCEDURE TEST.SLEEP_TEST()
LANGUAGE SQL
BEGIN
	CALL DBMS_OUTPUT.PUT_LINE('ONE:'||CURRENT_TIMESTAMP)
	CALL TEST.SLEEP(3)
	CALL DBMS_OUTPUT.PUT_LINE('TWO:'||CURRENT_TIMESTAMP)
END
/

call test.sleep_test()