Previous Topic: More InformationNext Topic: UNLOAD Syntax

Utility Statements › UNLOAD

UNLOAD

The UNLOAD utility unloads records from one or more areas of the database in preparation for reloading. The UNLOAD utility does not reload data.

Note: You cannot use UNLOAD to unload an SQL database that contains keys longer than 256 bytes. Instead, use the REORG utility instead of UNLOAD to reorganize a large key database.

Authorization

To

You Need This Privilege

On

Unload an area

DBAREAD
  • The area
  • Any area(s) with set connections to the area
  • Any area(s) containing an index defined on records in the area

Unload a segment

DBAREAD

All areas of the segment