DB2 Recovery Expert for Multiplatforms

252 DB2 Recovery Expert for Multiplatforms

COMM IS NULL;

COMMIT;

-- REDO UPDATE BARTR5.STAFF IN URID 0000000001E8

UPDATE BARTR5.STAFF

SET DEPT = 29

WHERE ID = 20 AND

NAME = 'Pernal' AND

DEPT = 20 AND

JOB = 'Sales' AND

YEARS = 8 AND

SALARY = 18171.25 AND

COMM = 612.45;

COMMIT;

-- REDO UPDATE BARTR5.STAFF IN URID 0000000001E8

UPDATE BARTR5.STAFF

SET DEPT = 29

WHERE ID = 80 AND

NAME = 'James' AND

DEPT = 20 AND

JOB = 'Clerk' AND

YEARS IS NULL AND

SALARY = 13504.60 AND

COMM = 128.20;

COMMIT;

-- REDO UPDATE BARTR5.STAFF IN URID 0000000001E8

UPDATE BARTR5.STAFF

SET DEPT = 29

WHERE ID = 190 AND

NAME = 'Sneider' AND

DEPT = 20 AND

JOB = 'Clerk' AND

YEARS = 8 AND

SALARY = 14252.75 AND

COMM = 126.50;

COMMIT;

-- RED ...