SQSH questions
Brian Bruns
camber at umcc.ais.org
Sat Oct 9 12:29:02 EDT 1999
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
More information about the FreeTDS
mailing list