View Single Post

   
  #3 (permalink)  
Old 04-08-2008, 06:16 PM
Cal
 
Posts: n/a
Default Re: Need to reconnect to ISQL

Sorry, I did not see any answer...


krithika wrote:
> Cal wrote:
> > Hi, all.
> >
> > I'm working with Sybase ASA ISQL 7.0.4.3423.
> >
> > Sometimes I launch time consuming process from ISQL. While it works, I
> > want to check the table, which this process is filling, to see the
> > progress. So, I launch another ISQL session, run count(*) against this
> > table and get a result. But, if I try to run count(*) again, I always
> > get the same result! Only thing that helps to get refreshed number is
> > to disconnect and connect again.
> >
> > It's a small thing, but it is annoying. Why ISQL acts like this? How to
> > get current amount of rows from table without disconnecting/connecting?
> >
> > Thanks!


Reply With Quote