Re: sqlexit()

Jon Strabala wrote: > > Art S. Kagel wrote: > > > > Mike Segel wrote: > > > > > > Art S. Kagel wrote: > > > > > > > > Rich Sedman wrote: > > > > > > > > > > Hi, I havn't been following this group so sorry if this has already been > > > > > covered or is in the faq. Anyway, I need to disconnect from a database > > > > > and server in 4gl 6.0 and above (online and SE) so that I can bring the > > > > > server down. I've found reference to a function sqlexit() but this > > > > > doesn't seem to exist. 'close database' doesn't quit the sql process > > > > > either. Anybody come across this before or got any better ideas how I > > > > > can do the equivalent of a 'disconnect all' in 4gl. > > Same problem Informix 7.X seems not to respond to sqlexit() anymore > in fact informix binaries are also subject to this problem try this > in isql or dbaccess using the editor > > database local;> close database; > database remote@remotehost; > close database; > > Run it again and agin and also do onstat in another window you will > see infinately growing connections. Perhaps this is some hidden > way to convince customers that the need to buy more licenses? > > - Jon No, I wrote a sample 4GL and ran it against 7.21 UD1 and it worked fine. I was even able to have the menu program run an onmode -ky. Closing a database doesnot drop the SQL connection. Please use deja news to see my last article in this thread. (I would repost but as Johnathan pointed out, I don't have enough room to fit two size 12 feet into my mouth :-) -Mike -- #include <std_disclaimer.h> /* Mike Segel (MS385) */ #include <No_Spam.h> #ifdef OFFENDED_BY_CONTENT The author takes no responsibility for this post. Any resemblence to a coherent rational thought is purely coincidence. -The Management. #endif ***************************** Due to AGIS's Refusal to Act Responsibly We are blocking all of their domains at the packet level. This block will exist until AGIS modifies their policies to conform to existing RFCs and net community standards. We encourage all ISPs and domain holders to do the same. *****************************