"waitfor delay" not working as expected....
Posted on 2007-03-30
On Sybase 11.9.2, running on AIX.
Here's what I'm experiencing, and I'm not sure why. Placed the following in a stp:
print 'WE START.'
waitfor delay '00:02:00'
print 'WE END.'
When I execute this, I'm was expecting to see "WE START", then have a two minute pause, and then see "WE END"....but instead, the two minute pause appears to occur FIRST, and THEN I see "WE START" "WE END" print one after another with no delay in between.... Can someone expain why that is? Is the print "WE START" actually running prior to the pause, but not actually printing until after? If so, how can I make it work as I'm expecting?