Subject RE: [firebird-support] Import data from flat files
Author Oleg Lebedev
Perfect, echo piping did the trick!

-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: Wednesday, October 01, 2003 3:33 AM
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

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

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

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

Haven't tried it though...

Milan Babuskov

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to


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.