Alphabetical listing of UNLOAD PLUS options


The following table lists the UNLOAD PLUS command options alphabetically and indicates where to find each option description. The final two columns in the table indicate whether the option is supported with DIRECT NO or DIRECT YES.

The following table describes UNLOAD PLUS command options:

Command option

Reference

DIRECT NO

DIRECT YES

ACTIVE

Yes

Yes

ANALYZE

Ignored

Yes

ASCII

Yes

Yes

AUTOTAG

Yes

Yes

CCSID

Yes

Yes

CENTURY

Yes

Yes

CLONE

No

Yes

CNTLCARDS

Yes

Yes

CNTLDDN

Yes

Yes

CURRENTDEGREE

Yes

Ignored

DATACLAS

Yes

Yes

DATEFMT

Yes

Yes

DDLDDN

No

Yes

DECFLOAT_ROUNDMODE

Yes

Yes

DELETEFILES

Yes

Yes

DIR

Yes

Yes

DIRECT

Yes

Yes

DISCARDS

Yes

Yes

DISKEXPD

Yes

Yes

DISKRETN

Yes

Yes

DRAIN_WAIT

Ignored

Yes

DSNAME

Yes

Yes

DSNTYPE

Yes

Yes

DSPLOCKS

Ignored

Yes

EBCDIC

Yes

Yes

ENUMROWS

Ignored

Yes

ESTROWS

Yes

Yes

EXPDT

Yes

Yes

FILESZPCT

Yes

Yes

FILL

Yes

Yes

FILTERPART

Ignored

Yes

FIXEDVARCHAR

Yes

Yes

FORCE

Ignored

Yes

FORCE_AT

Ignored

Yes

FORCE_DELAY

Ignored

Yes

FORCE_RPT

Ignored

Yes

FORMAT

Yes, except FORMAT BMCLOAD

Yes

GDGLIMIT

Yes

Yes

IMPLICIT_TZ

Ignored

Yes

INFILE

No

Yes

INTERVAL

Yes

Yes

INTO

Yes

Yes

LIMIT

Yes

Yes

LOGICAL PART

No

Yes

LRECL

Yes

Yes

MAXBLKSIZE

Yes

Yes

MAXCONNECT

Yes

Ignored

MAXPRIM

Yes

Yes

MAXSECD

Yes

Yes

MAXSORTS

Ignored

Yes

MGMTCLAS

Yes

Yes

NAME

Yes

Yes

NBRSECD

Yes

Yes

NOSUBS

Ignored

Yes

NULLCHAR

Yes

Yes

NULLTYPE

Yes

Yes

OBID

Ignored

Yes

ON FAILURE

Yes

Yes

ON MESSAGE

Ignored

Yes

OPTIONS

No

Yes

ORDER

Ignored

Yes

ORDER BY

Yes

Yes

OUTPUT

Yes

Yes

PART

No

Yes

PCTPRIM

Yes

Yes

RECFM

Yes

Yes

RECORDID

Yes

Yes

RETPD

Yes

Yes

RETRY

Ignored

Yes

RETRY_DELAY

Ignored

Yes

SELECT

Yes, with documented exceptions

Yes

SET CURRENT QUERY ACCELERATION ALL

Yes

No

SHRLEVEL

Ignored

Yes

SORTDEVT

Ignored

Yes

SORTNUM

Ignored

Yes

Ignored

Yes

SPACE

Yes

Yes

SPANNED

No

Yes

STORCLAS

Yes

Yes

SUBSETS

Ignored

Yes

SYNC

Ignored

Yes

TABLESPACE

No

Yes

TIMEFMT

Yes

Yes

TRTCH

Yes

Yes

TSFMT

Yes

Yes

UNICODE

Yes

Yes

UNIT

Yes

Yes

UNITCNT

Yes

Yes

UNLOAD

Yes

Yes

UNLOADDN

Yes

Yes

UNLOADEXIT

Yes

Yes

USELRECL

Yes

Yes

VOLCNT

Yes

Yes

VOLUMES

Yes

Yes

WTOMSG

Ignored

Yes

XBMID

Yes for zIIP processing

Ignored for snapshot processing

Yes

ZIIP

Yes

Yes

ZONEDDECOVP

Yes

Yes


 

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