Re: sqlexit()

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. > > 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 This kinda falls into the "Whydcha wanto dothat" (Why do you want to do that) catagory. Implicitly, you want to connect to the informix engine if you have a 4gl Program. So why would you want to have a 4GL program without a connection to the engine? IMHO, I don't think that it is possible. Anyone take the time to walk through the C code generated by the 4GL preprocessor? It would give you a clue how you could hack a way to do this. (And it would be a nasty hack!) -Mikey -- #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. *****************************