EXPORT

Short Reference

Syntax

EXPORT parameter_list TO medium [COMPRESSION {ON|OFF}].

Addition:

... COMPRESSION {ON|OFF}

Effect

: This statement stores a data cluster defined using parameter_list in a storage area medium. You can use the COMPRESSION addition to specify whether the data is stored in the cluster in compressed form. You can retrieve a data cluster from the storage area using the IMPORT statement and delete a data cluster using DELETE FROM.

All data objects are archived according to the current byte sequence (endian) and character-like data objects according to the character representation of the current text environment. The identification of the data cluster indicates which byte sequence and character representation have been used during the export. When the data cluster is imported using the IMPORT statement, this identification is evaluated and the data is converted to the current byte sequence and character representation.

Note

See also Classes for Data Clusters.

Addition

... COMPRESSION {ON|OFF}

Effect

: This addition specifies whether or not the data in the data cluster is compressed. By default, compression is deactivated for all memory areas apart from medium database tables. If compression is required, it must be switched on using ON. When storing in a database table, compression is switched on by default and is only switched off if you specify OFF.

Note

When a data cluster is imported using IMPORT, the system automatically recognizes whether or not the data is compressed.