UNLOAD

The UNLOAD control statement requests that all the rows from the DB2 table are to be written to a variable block sequential data set.

The following table describes the operands for the UNLOAD control statement.

Operand	Description
TYPE=accountingStatisticsTableType	Specifies the type of accounting or statistics table Possible values are: ACCT SUMACCT DDFACCT SUMDDFACCT PKGACCT SUMPKGACCT BUFACCT SUMBUFACCT STAT SUMMSTAT DDFSTAT SUMDDFSTAT BUFSTAT SUMBUFSTAT This required field has no default.
TYPE2=auditTableType	Specifies the type of audit table Possible values are: AUDFAIL AUDGRV AUDDDL AUDDML AUDDMB AUDCHG AUDUTL AUDSUM This required field has no default.
TYPE3=statisticsAuditTableType	Specifies the type of statistics or audit table Possible values are: ASPCSTOR SYSTSTOR AUDCMD AUDATH AUDTRC This required field has no default.
TYPE4=acceleratorSimBPTableType	Specifies the type of accelerator or simulated bufferpool table Possible values are: ACCA ACCS SYMB This required field has no default.
FROMTBL=tableName	Name of the table from which the rows are fetched This required field has no default.
TODD=ddName	ddName assigned to the file to which the rows are written This required field has no default.
UNLDSTART=yyyy-mm-dd,UNLDEND=yyyy-mm-dd	Limits the records that are unloaded. For example, UNLDSTART=2002-01-08,UNLDEND=2002-01-09 limits the records unloaded to those for the day of 2002-01-08.

On this page