Hi,
I'm using isql in a makefile. Is it possible to pass the isql
command a parameter that
will get it to return an error code if the sql that it processes has an error?

currently i'm doing something like this:

mydb.fdb: mydbfile1.sql somemore.sql
\tisql -i mydbfile1.sql -u user -p pass
\tisql -i somemore.sql -u user -p pass

right now if the sql in any of the input sql files fails the isql
command returns success, i.e 0.

Under some circumstances I can understand that this might be correct,
but there are
certainly many times when this is very inconvient.

I see that if the input file is not correctly parsed a error is returned 1.

Why not assign an alternate return value for sql execution errors, such as 2.

The only way i know to get make to work the way i need it would be to
redirect isql output
grep for failed and abort the makefile

I think it would be much nicer if I could at least just pass a
different argument to isql to get
isql to function correctly.

thanks,

-todd