Archives of the TeradataForum

Message Posted: Fri, 21 Oct 2005 @ 09:05:26 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This still seems like an odd request.

Since you are using V2R5.0 I am assuming you are trying to use Delay or Sleep as part of your stored procedure. These don't seem to be valid keywords for Stored Procedures, so it is no wonder that they don't work.

If you really need to delay a procedure you will need to invoke one of the 'C' functions (sleep or nap) which can only be done from a UDF. If memory serves, UDF's were first available in V2R5.1.

Again I can't see why anyone would want to slow things down (most other people want things to go faster). You might be better off putting the delay in the client application.

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>