|#575on PLDB||13Years Old||370Users|
SQL PL stands for Structured Query Language Procedural Language and was developed by IBM as a set of commands that extend the use of SQL in the IBM DB2 (DB2 UDB Version 7) database system. It provides procedural programmability in addition to the querying commands of SQL. It is a subset of the SQL Persistent Stored Modules (SQL/PSM) language standard. Read more on Wikipedia...
create procedure sleep (in sleeptime integer) begin declare wait_until timestamp; set wait_until = (current timestamp + sleeptime seconds); while (wait_until > current timestamp) do end while; end!