SESAM/SQL utility functions

SESAM/SQL provides utility functions through utility statements.

The table below shows the utility functions provided by SESAM/SQL and indicates which utility statements implement the individual utility functions.

Utility function	Utility statement
Modify properties of the database	ALTER CATALOG
Create a database (catalog space)	CREATE CATALOG
Create a SESAM backup copy	COPY
Create a replication	CREATE REPLICATION
Update a replication	REFRESH REPLICATION
Extend a replication	REFRESH SPACE
Recover a database, catalog space, user space(s)	RECOVER [USING]
Reset database, catalog space, user space(s)	RECOVER TO
Reset database to any time	RECOVER CATALOG [USING] TO ANY time_stamp
Rebuild indexes	RECOVER INDEX
Load user data into a base table	LOAD
Unload user data from base table	UNLOAD
Export table from database to an export file	EXPORT TABLE
Import table from export file into database	IMPORT TABLE
Shuffle column values, anonymize user data	ALTER DATA FOR TABLE
Reorganize the catalog space, user spaces or base tables	REORG
Changing the partitioning of a base table	ALTER PARTITIONING FOR TABLE
Check integrity constraints	CHECK CONSTRAINTS
Check the format of base tables and indexes	CHECK FORMAL
Edit media table	ALTER MEDIA DESCRIPTION CREATE MEDIA DESCRIPTION DROP MEDIA DESCRIPTION
Maintain information (metadata) on the SESAM backup copies	MODIFY
Migrate databases and tables	MIGRATE

Table 39: SESAM/SQL utility functions

In chapter “Building, loading and maintaining databases”, the utility statements are described in connection with the tasks involved in developing and maintaining a SESAM/SQL database.

The individual utility statements are described in full in the “SQL Reference Manual Part 2: Utilities”.