BMC AMI Unload Option descriptions


The following table describes the options that are available with the UNLOAD command.


Keyword

Reference

Valid with DIRECT NO
(or DIRECT AUTO when it converts to DIRECT NO)

ASCII

No

AUTOTAG

Yes

BLANKPAD

Yes

BYPART

No

CCSID

No

CNTLCARDS

Yes

CNTLDDN

Yes

CURRENTDEGREE

Yes

DATEFMT

Yes

DELETEFILES

Yes

DIRECT

Yes

DISCARDS

Yes

EBCDIC

Yes

ESTROWS

Yes

EXCLUDE

Yes

FILL

Yes

FILTERPART

Ignored

FIXEDVARCHAR

Yes

FORCE

Ignored

FORMAT

Yes

FROM

Yes

INFILE

No

INTO

Yes

LIMIT

Yes

LOGICAL PART

No

MAXSORTS


MINROWS

Yes

NOSUBS

Ignored

NULLCHAR

Yes

NULLTYPE

Yes

OBID

No

ON FAILURE

Yes

OPTIONS

No

ORDER

Ignored

ORDER BY

Yes

PART

No

RECORDID

Yes

SCHEMA

Yes

SELECT

Yes, with documented exceptions

SET CURRENT QUERY ACCELERATION ALL

No

SHRLEVEL

Ignored

SPANNED

No

TABLESPACE

No

TIMEFMT

Yes

TSFMT

Yes

UNICODE

No

UNLOAD

Yes

UNLOADDN

Yes

UNLOADDNPFX

Yes

UNLOADEXIT

Yes

ZONEDDECOVP

Yes

  

 

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