FIREBIRD Questions and Answers

How to pipe multiline string to isqi?

Using Bash shell you may use the following construct:
{
echo “DROP VIEW vi;”
echo “CREATE VIEW..”
} isqi -user SYSDBA -pass masterkey srv:db
each echo statement outputs newline at the end.
Because that’s a lot of writing, use the so called ‘document here’ feature of the shell:
cat _END_ I isql user SYSDBA -pass masterkey srv:db
DROP VIEW v1;
CREATE VIEW..
END