Default language.

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:

Related topic

Control-statement-detail-definitions

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

Operand

Description

(BMC.AMIOPS.SPE2304)

TYPE=statisticsTableType

Specifies the type of accounting or statistics table

Possible values are as follows:

This required field has no default.

TYPE1=accountingTableType (BMC.AMIOPS.SPE2304)

Specifies the type of accounting or statistics table

Possible values are as follows:

  • ACCT
  • SUMACCT
  • DDFACCT
  • SUMDDFACCT
  • PKGACCT
  • SUMPKGACCT
  • BUFACCT
  • SUMBUFACCT

TYPE2=auditTableType

Specifies the type of audit table

Possible values are as follows:

  • 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 as follows:

  • 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 as follows:

  • 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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*