BEFORE JOURNAL in Teradata

Why we go for Before Journal ?

Suppose, your company wants you to increase the salary of employees by 10%. But you increased by 20%. In this scenario, you can make use of BEFORE JOURNAL by manual rollback and BEFORE JOURNAL will be used generally when there is a programmatic error.

CREATE TABLE forgetcode.tbl_name
FALLBACK,
BEFORE JOURNAL,
NO AFTER JOURNAL
( field1 INTEGER,
field2 INTEGER)
PRIMARY INDEX field1;


In the above code, user specifies BEFORE JOURNAL only.