Oninit cdi / Archive
Talk to an expert →

Re: SQL Query hang

Posted in 2003

Topics: SQL Development & Query Writing, Error Codes & Troubleshooting, Server Administration

Anu_R — — source: Usenet: comp.databases.informix

Thanks!! Unfortunately i have only dbaccess. Can I do the same in dbaccess: Session:1 Lock the table Session:2 SELECT * from table Will that hang? I think it will return a ISAM error code and not hang. Any thoughts? Anu_R -- Posted via http://dbforums.com

↪ replying to Anu_R
Gorazd Hribar Rajteri��� — — source: Usenet: comp.databases.informix

It depends on how you have configured waiting time in Session2. If you SET LOCK MODE TO WAIT 0 it will wait indefinitely. Gorazd "Anu_R" <member30973@dbforums.com> wrote in message news:3384104.1063857165@dbforums.com... > > Thanks!! Unfortunately i have only dbaccess. Can I do the same in > dbaccess: > > > > Session:1 > > > > Lock the table > > > > Session:2 > > > > SELECT * from table> > > > Will that hang? I think it will return a ISAM error code and not hang. > > > > Any thoughts? > > Anu_R > > > -- > Posted via http://dbforums.com

Glossary