Hi,

> We have MSSQL db where we can run batch scripts through a
> general "execute(sql)" method call. Now we tried similar query in
> Firebird but it failed.

Firebird does not allow to run multiple SQL statements in one query.
You have to split them.

Best regards,
Roman Rokytskyy