Re: time delay in *.sql file

Anitha Prasad <anitha@aix5.bgs.com> wrote: :Hello, :I need to add time delay( something like sleep 100 on unix) besfore my :transaction closes the database. :To make myself clear. For example I have a file delete.sql: : :DATABASE customer; :DELETE * from customer where c_num>2500; : :When I execute this at the command line using: :$INFORMIXDIR/bin/dbaccess - delete.sql : :The following occurs on the screen: :Database selected :300 rows deleted :Database closed : :This happens too fast and hence I need to include something like: : :DATABASE customer; :DELETE * from customer where c_num>2500; :some time delay :CLOSE DATABASE; : :How do I accomplish this. : :We are using 7.20.UC3 engine . :I appreciate any suggestions. I am at a loss to understand why it can happen to fast. Don't we all want it to run as fast as possible? Anyway there is no sleep or other time delay statement in sql. All I could suggest is adding some sql statement that would take a more or less predictable time to execute, but otherwise did nothing detrimental. (May be something like: unload to "/dev/null" select * from sometable) Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org