Hi,

running FB 1.0.3 on Linux I need to execute a lot of
scripts using isql, sometimes also shell inline scripts
like
cat <<- EOT | isql .....
<statement>
<statement>
EOT

Now my questions:
Is there any possibility to get the result of a sql statemetn
within the (sql) script out of 'isql'?
Is there a possibility to exit the (sql) script depending on
the result (SQLCODE?) of the previous statement?
Is there an analogous command (for 'isql') like
'WHENEVER .... EXIT ROLLBACK' (as in ORACLE). I know, that
this is an Firebird-ESQL statement, but is there something
like that for 'isql'?

Thanks

Roger