HPlogo ALLBASE/SQL Reference Manual > Chapter 10 SQL Statements A - D

BEGIN ARCHIVE

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7

The BEGIN ARCHIVE statement in conjunction with the COMMIT ARCHIVE statement starts a new archive log file before a static backup is done to a DBEnvironment. However, this method is no longer recommended. The recommended approach to initiate archive logging and dynamic backup is to use the SQLUtil STOREONLINE command.

Scope

ISQL or Application Programs

SQL Syntax


  BEGIN ARCHIVE

Description

Use of the BEGIN ARCHIVE statement is no longer recommended. Refer to the ALLBASE/SQL Database Administration Guide for detailed backup and recovery procedures and recommended practices.

Authorization

You must have DBA authority to use this statement.



BEGIN

BEGIN DECLARE SECTION