User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To checkpoint the database.

Syntax

     CHECKPOINT

Usage

Anywhere.

Permissions

Must have DBA authority to CHECKPOINT when you are running with multiple users over a LAN. For single-user, no authorization is required.

Side effects

None.

Description

The CHECKPOINT statement will checkpoint the database. Checkpoints are also performed automatically by the database engine. It is not normally required for an application to ever issue the CHECKPOINT statement. For a full description of checkpoints, see "Backup and Data Recovery".