Use CHECKPOINT to generate the checkpoint for the journal used in the recovery (the one for the data tables that will be rolled back).
With this option, Teradata ARC scans the journal table for the identified checkpoint. If that checkpoint does not exist, Teradata ARC returns an error.
If an unqualified chkptname is used and there are multiple rows in the journal table that all have the same name, Teradata ARC uses the last chronological entry made. In the ROLLFORWARD statement, on the other hand, Teradata ARC uses the first chronological 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.