Re: Informix:How do you Wait/sleep in Stored Procedure Code?

Posted in 2005

Michael Krzepkowski — Tue, 22 Mar 2005 19:51:26 GMT — source: Usenet: comp.databases.informix

jayloub wrote: > I am trying to write a procedure that will delete a specific # of rows > then pause for a few seconds before continuing. > > I have tried sleep <Number>; but that doesn't seem to be working. > > Please help. > call "system" with sleep command. It will go out to the OS to run it. BTW: Why would you do that? You can have begin work/commit blocks if you are concerned about long transactions. HTH Michael