Neat fix to isql replacement tool "is"

#11

Thomas Gagné <tgagne (AT) wide-open-west (DOT) com> wrote in
news:403F7217.9060104 (AT) wide-open-west (DOT) com:

Quote:

I wonder how difficult that would be. Of course it would be
easier using ODBC, but setting up ODBC on Linux seems a hassle.
I've started it a couple times but never got all the right
components.

I think Scott did a pretty good job of abstracting. It would
require work of course to convert CTLib to OCI equivalents. But I
don't think it'd be too tough.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

#12

Thomas Gagné <tgagne (AT) wide-open-west (DOT) com> wrote in
news:403F71C9.2080003 (AT) wide-open-west (DOT) com:

Quote:

is does the redirection as well with syntax similar to sqsh. I like
where sqsh puts the redirection--after the "go". I didn't notice if
sqsh supports input redirection--allowing SQL to be read from
multiple places. It probably does.

Are you considering taking over 'sqsh' ?

--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

#13

"Ed Avis" <ed (AT) membled (DOT) com> wrote

Quote:

How does your 'is' program compare with 'sqsh'?

--
Ed Avis <ed (AT) membled (DOT) com

IMO, sqsh is more user-friendly for everyday manual querying purposes
(life without sqsh is hard for me...). Thomas' 'is' has the unique
feature that a result set can be formatted as XML or HTML without any
programming effort.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

#14

Not yet. I'm already derelict in my attentions to isectd, an open
source middleware package (very lightweight and easy to use). I'm also
working on an open source Smalltalk interface to OpenLDAP, using algebra
to solve and express weights, measures, and currencies in Smalltalk, and
outlining a book on teaching OO programming with Golf.

Pablo Sanchez wrote:

Quote:

Thomas Gagné <tgagne (AT) wide-open-west (DOT) com> wrote in
news:403F71C9.2080003 (AT) wide-open-west (DOT) com:

is does the redirection as well with syntax similar to sqsh. I like
where sqsh puts the redirection--after the "go". I didn't notice if
sqsh supports input redirection--allowing SQL to be read from
multiple places. It probably does.

Are you considering taking over 'sqsh' ?

--
..tom
remove email address' dashes for replies
opensource middleware at <http://isectd.sourceforge.net>
http://gagne.homedns.org

#15

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote:

Quote:

On Fri, 27 Feb 2004 11:21:22 +0000, Pablo Sanchez wrote:

Thomas Gagn? <tgagne (AT) wide-open-west (DOT) com> wrote in
news:403EC32F.7030601 (AT) wide-open-west (DOT) com:

Ah! I also notice sqsh was rewritten with ctlib,

How about you take over sqsh and put in the features of 'is'?

I like sqsh's use of GNU readline.

and redirection.

Those are the two things I use most.

Yep, and \bcp comes third. It's so easy to copy the result of a
select (without creating a view) into a table on the same or
another server.

Someone should build in longer varchar support ...

Luc.

#16

On Sat, 28 Feb 2004 15:41:28 +0000, Luc Van der Veurst wrote:

Quote:

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote:
On Fri, 27 Feb 2004 11:21:22 +0000, Pablo Sanchez wrote:

Thomas Gagn? <tgagne (AT) wide-open-west (DOT) com> wrote in
news:403EC32F.7030601 (AT) wide-open-west (DOT) com:

Ah! I also notice sqsh was rewritten with ctlib,

How about you take over sqsh and put in the features of 'is'?

I like sqsh's use of GNU readline.

and redirection.

Those are the two things I use most.

Yep, and \bcp comes third. It's so easy to copy the result of a
select (without creating a view) into a table on the same or
another server.

Someone should build in longer varchar support ...

I've been looking at that, but I haven't had the time/energy to really
figure it out yet.

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

#17

On Sat, 28 Feb 2004 14:39:33 +0100, Rob Verschoor wrote:

Quote:

"Ed Avis" <ed (AT) membled (DOT) com> wrote in message
news:l1ishtldwb.fsf (AT) budvar (DOT) future-i.net...
How does your 'is' program compare with 'sqsh'?

--
Ed Avis <ed (AT) membled (DOT) com

IMO, sqsh is more user-friendly for everyday manual querying purposes
(life without sqsh is hard for me...). Thomas' 'is' has the unique
feature that a result set can be formatted as XML or HTML without any
programming effort.

I suspect that adding such a feature to sqsh would be fairly
straightforward.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Neat fix to isql replacement tool "is"

comp.databases.sybase comp.databases.sybase

Re: Neat fix to isql replacement tool "is" - 02-27-2004 , 10:48 AM

Re: Neat fix to isql replacement tool "is" - 02-27-2004 , 10:49 AM

Re: Neat fix to isql replacement tool "is" - 02-28-2004 , 07:39 AM

Re: Neat fix to isql replacement tool "is" - 02-28-2004 , 07:42 AM

Re: Neat fix to isql replacement tool "is" - 02-28-2004 , 09:41 AM

Re: Neat fix to isql replacement tool "is" - 02-28-2004 , 11:04 AM

Re: Neat fix to isql replacement tool "is" - 02-28-2004 , 11:05 AM