Skip to Content.
Sympa Menu

freetds - Re: SQSH questions

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: SQSH questions
  • Date: Sat, 9 Oct 1999 12:29:02 -0400 (EDT)




On Sat, 9 Oct 1999, Jeff Driscoll wrote:

> Questions somewhat unrelated to freetds - forgive me.
>
> 1. Is there an active mailing list or support mechanism for SQSH? The
> mailing list at sgi.com is non existant.
>
> 2. Problems executing a SQL command from the command line. What am I
> doing wrong?
>
> This works:
>
> [20] mssql..1> select count(*) from LOCFI;
>
> -----------
> 9668
>
> (1 row affected)
>
> This also works
> $ cat jeff.sql
> select count(*) from LOCFI;
> $ sqsh -b -S mssql -U popeye -P spinach -i jeff.sql
>
> -----------
> 9668
>
> (1 row affected)
>
> But this doesn't:
>
> $ sqsh -b -S mssql -U popeye -P spinach -C 'select count(*) from LOCFI;'
> $
>
If I had to guess, the semicolon hack probably doesn't work from the -C
flag. Try leaving the semicolon off.

Brian





Archive powered by MHonArc 2.6.24.

Top of Page