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.
>
>
Hi,
It can be several reasons.
Try ##7, 20, 21, 23 from this list
https://www.ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
Regards,
Alexey
On 15.08.2017 19:50, anderphil...@hotmail.com [firebird-support] wrote:
Hi, I have a strange problem which is probably quite obvious
15.08.2017 18:50, anderphil...@hotmail.com [firebird-support] wrote:
> 4x Intel(R) Xeon(R) CPU X5650 @ 2.67GHz
>
> physical memory: 4096 MB
> 7gb disk free
>
> Firebird 2.5.3 x64 super server
> Windows 2008 R2
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
Now it works... no one will convince me computers are deterministic.
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.
>
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.
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
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
10 matches
Mail list logo