CHECKPOINT Example | SQL Statements | Teradata Vantage - 17.05 - CHECKPOINT Example - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following request can be used to place a checkpoint entry into a journal table:

     CHECKPOINT account_db.jnl_table, NAMED daily_pay_maint;

When this request is executed, all update activity is ceased on tables that write journal images to the journal table, (jnl_table) and an event number is returned.

A row containing the daily_pay_maint label is placed into the journal table. The label can then be used in rollforward or rollback operations.