The database administrator can use the utility statement EXPORT TABLE to write a base table which can be partitioned from a SESAM/SQL database to a variable record-length SAM file.
This creates a so-called export file that can only be interpreted by IMPORT TABLE. The exported table and the new table generated on the basis of the export file have the same structure.
The export file is created with a coded character set name (CCSN) in accordance with the database’s character set.
The following metadata of the database is stored in the export file:
the metadata of the base table and all the associated columns
the metadata for all the indexes relating to this base table
the metadata for all the integrity constraints with the exception of the reference constraints defined in this base table
You can use a WHERE clause to restrict the volume of user data that is to be transferred to the export file. The export file cannot be processed manually.