CORE-POS/IS4C

use opdata;

update globalvalues set transno = 1, loggedin = 0;

insert into translog.suspended select * from translog.localtemptrans;
insert into translog.activitylog select * from translog.activitytemplog;
insert into translog.localtrans select * from translog.dtransactions;

truncate table translog.localtemptrans;
truncate table translog.activitytemplog;
truncate table translog.dtransactions;

insert into translog.alog select * from translog.activitylog;
insert into translog.localtransarchive select * from translog.localtrans;

truncate table translog.activitylog;
truncate table translog.localtrans;