Re: SQL Query hang

If you have 4GL at your disposal, then write a simple program that locks a record or a whole table and wait for some input. All SQL scripts and other programs accessing this record/table from other sessions will hang. Example of 4GL program: DATABASE sampleDB MAIN DEFINE cDummy CHAR(1) SQL LOCK TABLE myTable IN EXCLUSIVE MODE END SQL PROMPT "Press enter after finished..." FOR cDummy END MAIN Gorazd "Anu_R" <member30973@dbforums.com> wrote in message news:3376504.1063729695@dbforums.com... > > 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