Unload features

Change overpunch values during unload

17

Convert data during unload

2, 17, 18

Translate data during unload

18

Create a new field during unload

3

Use multiple SELECT statements

3, 4, 8, 9, 11, 13

Unload from prior image copy

10

Unload an entire table space

18

Use a DDLIN file

11

Unload to a CSV file

12

Unload to Unicode format

18

Unload selected columns

2, 4, 8, 13, 15

Unload selected partitions

5, 6, 10

Unload selected rows

4, 5, 6, 7, 13, 14

Use a subselect to unload selected rows

13

Use a join to unload selected rows

13

Use columnar functions during unload

13

Unload using DB2 dynamic SQL

13, 14, 15

Handle an abnormal termination

14

Specify a nonstandard null indicator

15

Unload zoned decimal data

17

Use high-speed data migration with LOADPLUS

19

Unload XML data

15

Unload LOB data

15

Write to referenced files

15

Object types

Nonpartitioned table space

3, 8, 9, 11, 13, 14, 15, 17, 18

Partitioned table space

1, 2, 4, 5, 6, 7, 9, 10, 12, 16, 19

DSN1COPY

5

Full image copy

6

Incremental image copy

10

Command options

ACTIVE NO

10, 12, 13, 14, 17, 18

ACTIVE YES

16

ANALYZE DB2STATS

16

AUTOTAG

18

CNTLCARDS

3, 5, 7, 8, 13, 15, 17, 18, 19

CNTLDDN

8

CONSISTENT YES

4

CURRENTDEGREE

13

DATEFMT

6

DELETEFILES

14

DIR

15

DIRECT NO

13, 14, 15

DIRECT YES

15

DSNAME

7, 9, 15, 16, 19

DSNTYPE

15

ENUMROWS

9

ESTROWS

7

FILTERPART

7

FORMAT

12, 15, 17, 19

FIXEDVARCHAR

2, 17

IF NULL VALUE or IF predicate VALUE

2

IMAGECOPY

6, 10

INCREMENTAL

10

INFILE

5, 6, 10, 11

INTERVAL

4

INTO

1, 2, 3, 8, 15, 16, 17,19

LIMIT

2, 4

NULLCHAR

15

NULLTYPE

15

OBID

5, 11

ON FAILURE

14

ORDER YES

2, 3, 19

ORDER BY

6, 9

OUTPUT

7, 9, 15, 16, 19

PART

5, 6, 10

RECORDID

8

RETCODE

14

SELECT

All examples except 18

SHRLEVEL CHANGE

4

SORTDEVT

3

SPACE

15, 16, 19

SUBSETS

15

TABLESPACE

18

TSFMT

6

UNLOADDN

8, 10, 12, 13, 14, 16, 17, 18

UNICODE

18

UNIT

15, 16, 19

WHERE clause

4, 5, 6, 7, 14

XBMID

4

ZONEDDECOVP

17