Kjell,
There is a product called IBEXPERT. This product is an IDE but also has a set
of command line utilities that allow you to perform scripting from a windows
CMD shell. It is very powerful. It has functions for working with files, ftp
servers, sending emails, etc.
Here is the link to
Kjell,
> We're in need of a tool where we can author sequences of SQL queries
> against FB and non-DB commands like file operations etc. I'd like to call them
> "batch runs" to perform recurring tasks.
>
> Do you know of such tools or what that kind of tool would be called in
> general?
>
> We
On 15-8-2017 15:36, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> We're in need of a tool where we can author sequences of SQL queries
> against FB and non-DB commands like file operations etc. I'd like to
> call them "batch runs" to perform recurring tasks.
>
>
Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] skrev:
> 15.08.2017 15:36, Kjell Rilbe kjell.ri...@marknadsinformation.se
> [firebird-support] wrote:
>> We're in need of a tool where we can author sequences of SQL queries against
>> FB and non-DB
>> commands like file operations etc.
15.08.2017 15:36, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> We're in need of a tool where we can author sequences of SQL queries against
> FB and non-DB
> commands like file operations etc. I'd like to call them "batch runs" to
> perform recurring
> tasks.
>
Hi,
we are using combination of bat and SQL.
In bat file we are generating SQL and vice versa.
Some example:
@SET sql=s1.sql
@ECHO SET TERM ^^; >%sql%
@ECHO EXECUTE BLOCK AS>>%sql%
@ECHO DECLARE VARIABLE s VARCHAR(1000);>>%sql%
@ECHO BEGIN>>%sql%
@ECHO s = 'CREATE USER %3 PASSWORD