To set the point in time that ROLLFORWARD (or ROLLBACK) rolls to, a CHECKPOINT statement must have been previously issued with the same value for chkptname. For example, if CHECKPOINT statements with different checkpoint names (for example, check1, check2, check3) were issued, use the same names in the ROLLFORWARD or ROLLBACK statement. Doing so returns the table to the state it was when each CHECKPOINT statement was originally issued.
If this option is specified, Teradata ARC first scans the journal table for the identified checkpoint. If the checkpoint does not exist, Teradata ARC returns an error.
If an unqualified chkptname is used, and there are multiple checkpoint rows in the journal table with the same name, Teradata ARC uses the first chronological entry made. Note this difference from the ROLLBACK statement, where Teradata ARC uses the last entry made.
Alpha characters in a chkptname are not case sensitive; for example, chkptname ABC is equal to chkptname abc. If this option is not specified, Teradata ARC uses the entire journal table.