Re: Need to reconnect to ISQL

From: "krithika" <shanthikonda@xxxxxxxxx>
Date: 26 Jan 2006 00:59:26 -0800

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!

.

Follow-Ups:
- Re: Need to reconnect to ISQL
  - From: Cal

References:
- Need to reconnect to ISQL
  - From: Cal

Prev by Date: Need to reconnect to ISQL
Next by Date: Re: Need to reconnect to ISQL
Previous by thread: Need to reconnect to ISQL
Next by thread: Re: Need to reconnect to ISQL
Index(es):
- Date
- Thread

Relevant Pages

Need to reconnect to ISQL
... Sometimes I launch time consuming process from ISQL. ... to disconnect and connect again. ...
(comp.databases.sybase)
Re: Need to reconnect to ISQL
... >> Sometimes I launch time consuming process from ISQL. ... >> to disconnect and connect again. ...
(comp.databases.sybase)
Re: Need to reconnect to ISQL
... > Sometimes I launch time consuming process from ISQL. ... So, I launch another ISQL session, run countagainst this ... others shouldn't see the uncommitted work. ...
(comp.databases.sybase)