Non-shell execution of sqsh

[Sue Greer]

I've just started using sqsh, and it's excellent! I've been successful running the following command:

sqsh -S <server> -U <user> -P <password> -D <database> -i <infile> -o <outfile>

with the following command in the <infile>:

select top 1 time_tag from tb_mytable order by time_tag
go

However, there's an option (-C) which supposedly allows the sql command to be given along with the other options (user, password, etc.) with the output going either to standard out or to the <outfile>. I haven't been able to get this to work. All the documentation seems to be about using sqsh as a shell. Does anyone know a simple example of how to use the -C option?