iAnywhere.com - CREATE COMPRESSED DATABASE statement (deprecated)

CREATE COMPRESSED DATABASE statement (deprecated)

Description

Use this statement to create a compressed database from an existing database file, or to expand a compressed database.

Deprecated statement

The use of compressed databases is deprecated.

Syntax

CREATE [ COMPRESSED | EXPANDED ] DATABASE new-db-file-name
FROM old-db-file-name [ KEY key ]

Usage

Creates a compressed database file from an uncompressed database file, or an uncompressed database file from a compressed one.

Any relative path is resolved relative to the current working directory of the server.

You cannot use this statement on files other than the main database file.

Caution Compressing an encrypted database removes encryption from the database.

Permissions

The permissions required to execute this statement are set on the server command line, using the -gu option. The default setting is to require DBA authority.
The operating system account under which the server is running must have write permissions on the directories where files are created.
The old database file must not be currently running.
Not supported on Windows CE.
You must specify a key if you want to create a compressed database for a strongly encrypted database.

Standards and compatibility

SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.

Example

The following statement creates a compressed database file named compress.db in the C:\ directory from a database file named full.db in the current working directory of the server.

CREATE COMPRESSED DATABASE 'C:\\compress.db'
FROM 'full.db'

The following statement creates an uncompressed database file named full.db in the C:\ directory from a compressed database file named compress.db in the current working directory of the server.

CREATE EXPANDED DATABASE 'C:\\full.db'
FROM 'compress.db'