ASA SQL Reference

SQL Statements

CHECKPOINT statement

Description 

Use this statement to checkpoint the database.

Syntax 

CHECKPOINT

Usage 

The CHECKPOINT statement forces the database server to execute a checkpoint. Checkpoints are also performed automatically by the database server according to an internal algorithm. It is not normally required for applications issue the CHECKPOINT statement.

For a full description of checkpoints, see Backup and Data Recovery.

Permissions 

DBA authority is required to checkpoint the network database server.

No permissions are required to checkpoint the personal database server.

Side effects 

None.

See also 

• CHECKPOINT_TIME option [database]
• RECOVERY_TIME option [database]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Adaptive Server Enterprise.

SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.