SQL Query hang

Hi Everyoe, I am using IDS 9.3. I have a very tricky situation to deal with. Here it is: I have to issue a SELECT Query on a user defined database/table which will hang. And most important : it should be the only statement I issue in that particular dbaccess session. I am also thinking if there is a way to corrupt a database so that the SELECT statement does not work.... Please ... help... Regards, Anu_R -- Posted via http://dbforums.com

On Tue, 16 Sep 2003 12:28:15 -0400, Anu_R <member30973@dbforums.com> wrote: > >Hi Everyoe, > > > >I am using IDS 9.3. > > > >I have a very tricky situation to deal with. Here it is: > > > >I have to issue a SELECT Query on a user defined database/table which >will hang. And most important : it should be the only statement I issue >in that particular dbaccess session. > > > >I am also thinking if there is a way to corrupt a database so that the >SELECT statement does not work.... > > > >Please ... help... > > > Please post.... 1. the query itself 2. the schema(s) for the affected table(s) 3. the query plan

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