Re: How do I disconnect from database from 4gl

Phuoc Ho wrote: } } How can we disconnect from the database and see no connection } in onstat -u. We have tried various "close database", "disconnect" } but no thing seems to work. Did anyone try this? } } We basically need to run a 4gl program that will only connect } to the database on command. } } Thanks in advance } } We are using: ONLINE 7.23 and Informix 4gl v 6.01 Hi: Look at the sqlexit(), sqldetach() and sqlstart() functions. They are docummented on the ESQL/C programmer's manual so I am not sure if you can use them directely from 4GL. You, always, can write a c function that uses them. We use these functions on ESQL/C programs and never had any problem. Tino