Perfect, echo piping did the trick!
Thanks.

-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: Wednesday, October 01, 2003 3:33 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Import data from flat files
Importance: Low


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




To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

*************************************

This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.

*************************************