So, these are the maintenance actions that I am going to perform every night(I
have a gap between 1am and 7 am):
- In the main server
- Backup using gbak.
- Restart o of the database to get rid of long transactions
- Sweep.
- In the backup server
- Restore of t
i have this heterogeneous cross database query
execute block as DECLARE panum INT; DECLARE nom varchar(50); DECLARE
prenom varchar(50); DECLARE dna date; DECLARE datemodif date; DECLARE
m date; DECLARE VARIABLE VSQL VARCHAR(100); begin
VSQL = 'select panum, nom, prenom, dna, DATEMODIF from patie
On 2018-05-05 19:49, Issam Boughanmi amigof...@gmail.com
[firebird-support] wrote:
> i have this heterogeneous cross database query
>
> execute block as
> DECLARE panum INT;
> DECLARE nom varchar(50);
> DECLARE prenom varchar(50);
> DECLARE dna date;
> DECLARE datemodif date;
> DECLARE m date;
>
yep !
i have noticed that after posting :p
sometimes all what you have to do is to take a deep breath and take a
closer look on your code ...
thanks .
2018-05-05 19:44 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] :
>
>
> On 2018-05-05 19:49, Issam Boughanmi amigof...@gmail