@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Tuesday, August 15, 2017 9:36 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Automation tools?
Hi,
We're in need of a tool where we can author sequences of SQL queries against FB
and non-DB commands like file
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
Hi,
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 need to be