Oleg Lebedev wrote:

> Ok, great.
> I am wondering if there is a way to execute an SQL command through some
> FB utiltity from a shell. Smth like:
> bash> time isql -c "SELECT count(*) FROM tableA" /tmp/mydb.fdb

You can either put it in some file (ex. file.sql) and do something like
this:

isql -i file.sql /tmp/mydb.fdb

Since isql reads input from stdin, I guess you can do one-liners like this:

echo "SELECT count(*) from tableA" | isql /tmp/mydb.fdb

Haven't tried it though...

--
Milan Babuskov
http://fbexport.sourceforge.net