Not strictly Sybase, but perhaps of interest, especially for those
of use who rely on FreeTDS libs to get Sybase and SQL Server talking.

David Gray should live a long happy healthy and properous life for
giving us sqsh. But it has one major irritant. If I control-C while
a long select is running, it doesn not return me to the prompt. It
seems to go off into neverland. Eventually I control-Z and do a kill -9
on the sqsh process.

I took a look at the code and decided I wasn't going to jump right in with dbx
and start figuring out why it doesn't handle it nicely. Thought I'd ask
around and see if anyone else has the problem and has fixed it, and
if so if you'd care to share the hack.

Don't know sqsh? See www.sqsh.org - a wonderful extension of isql.
Many of its features are in and of themselves sufficient reason to
use it. Fabulous stuff, but David Gray is not in a position to maintain
and delvelop it anymore - not that he should have to, he's done plenty!

But I do wish it would handle signals as well as isql does.



--
r l reid ro (AT) rreid (DOT) net

On Thu, 19 Feb 2004 17:01:18 +0000, r l reid wrote:

(err - that's Scott Gray :-)

But it has one major irritant. If I control-C while
Hmmm - I really suspect that this is a FreeTDS problem. I use sqsh
everyday (with Sybase libs), and haven't seen this problem at all.

I seem to remember some recent discussions about signals on the FreeTDS
mailing list - you may want to check them out.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

In <pan.2004.02.19.18.54.18.410203 (AT) peppler (DOT) org> Michael Peppler <mpeppler (AT) peppler (DOT) org> writes:

and I *do* know it's Scott!

Much obliged.
--
r l reid ro (AT) rreid (DOT) net

Hello,

There was an Open Client bug where they broke
signal handling so interrupts like ^C would not
work. Depending on what version of Open Client
your are running, this problem could be an Open Client
bug and not specific to SQSH at all.

If you try using ISQL and try control-C on a long
query, does it also fail to respond?

What version of Open Client are you running?
isql -v
and/or
strings -a $SYBASE/$SYBASE_OCS/lib/libct.so | grep Sybase

r l reid wrote: