FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

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