RE: SQL Query hang

Posted in 2003

Dirk Moolman — Wed, 17 Sep 2003 10:47:34 +0200 — source: Usenet: comp.databases.informix

I am not sure what you are trying to do, but you could lock a record in a table, then you can run your SELECT by setting lock mode to wait first, and selecting the locked record ...... -----Original Message----- From: Anu_R [mailto:member30973@dbforums.com] Sent: Wednesday, September 17, 2003 5:24 AM To: informix-list@iiug.org Subject: Re: SQL Query hang Hi John, I dont have any query/query plan/schema. I need to create a new simple database myself and think of SELECT statement that would hang. But most important as I mentioned is, it should be a SELECT statement that is hanging and should be only statement in the session. I was also thinking if a dbspace is down will a SELECT statement execute? OR can I corrupt the database such that any SQL statement will hang. Anu_R -- Posted via http://dbforums.com sending to informix-list