Subversion Repositories Brabant Water.oosterhout

close;
connect d:\data\trend;
log F:\20080402.TR1;
select * from TREND1 where TIME > 891561600 and TIME < 891648000 ORDER BY TIME;
log off;
log F:\20080402.TR2;
select * from TREND2 where TIME > 891561600 and TIME < 891648000 ORDER BY TIME;
log off;
log F:\20080402.TR3;
select * from TREND3 where TIME > 891561600 and TIME < 891648000 ORDER BY TIME;
log off;
log F:\20080402.TR4;
select * from TREND4 where TIME > 891561600 and TIME < 891648000 ORDER BY TIME;
log off;
log F:\20080402.TR5;
select * from TREND5 where TIME > 891561600 and TIME < 891648000 ORDER BY TIME;
log off;
close;

connect d:\data\alarmen;
log F:\20080402.ALM;
select ITIME, MSG from alarms where ITIME > 20080402000000.000 and ITIME < 20080403000000.000 ORDER BY ITIME;
log off;
close;

quit;