Re: sqlexit()

In article <340C620A.4095@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes > >The 6.0 4GL libraries do indeed have both sqlexit() and sqldetach() >(do: nm $INFORMIXDIR/lib/tools/*.a | fgrep sqlexit to search). But, >both are "C" functions which take no arguments and returns an integer >(0 if successful <0 if not successful). You will have to write 4GL >callable wrappers for these. > >Art S. Kagel Thanks for your help - this worked a treat. The original problem was that we needed to run a batch job which would potentially lock the database so shutting down the server was the easiest way of ensuring any users who hadn't logged out would be kicked off. Since the batch job is selected from a standard informix based menu system it needs to be disconnected from the server while it was brought down. The other benefit is that since the menu program disconnects from the server it no longer has a user thread. Our application can sometimes have 3 4gls running for each user so theres a great overhead in the connections to the database alone (esp on SE). Thanks again, Rich -- acrid@herdsman.demon.co.uk