Examples of UNLOAD PLUS jobs

Each example includes the following information:

A description of the unload job
The UNLOAD PLUS job stream
The SYSPRINT from the job

Some examples show additional information that might be useful to understand a particular feature or to see the results of the unload job.

Related topics

Running-UNLOAD-PLUS-jobs

Tuning-UNLOAD-PLUS-jobs

Building-the-UNLOAD-PLUS-job

All of these examples have the following common properties:

These examples use a single BMC product load library, assuming that this library contains the UNLOAD PLUS load files and the common component load files that UNLOAD PLUS requires.
The examples use minimal data set space allocations in the JCL.

You can find copies of the JCL for these examples in members ADUXMnn (where nn is the example number) in the HLQ.LLQCNTL installation data set (where HLQ is the high-level qualifier specified during installation and LLQ is the low-level qualifier or prefix set during installation). The HLQ.LLQCNTL data set also includes the member ADUXM00 which contains the following elements:

DDL for the table spaces
Sample data to load into the table spaces
Load jobs to load the data

For syntax details, see Command-and-syntax-reference. For information about JCL statement requirements, see Building-the-UNLOAD-PLUS-job.

Use the following table to locate an example of a specific unload type or option:

Functions	Relevant examples
Unload features
Change overpunch values during unload	Example 17 — Changing overpunch values in zoned decimal data
Convert data during unload	Example 2 — Unloading columns in clustering order Example 17 — Changing overpunch values in zoned decimal data Example 18 — Unloading a table space and loading data as Unicode
Translate data during unload	Example 18 — Unloading a table space and loading data as Unicode
Create a new field during unload	Example 3 — Unloading multiple tables to a single data set
Use multiple SELECT statements	Example 3 — Unloading multiple tables to a single data set Example 4 — Unloading while allowing read write access to the table space Example 8 — Using multiple SELECT statements Example 9 — Unloading from multiple table spaces Example 11 — Using a DDLIN data set Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism
Unload from prior image copy	Example 10 — Unloading from incremental image copies
Unload an entire table space	Example 18 — Unloading a table space and loading data as Unicode
Use a DDLIN file	Example 11 — Using a DDLIN data set
Unload to a CSV file	Example 12 — Unloading to CSV format
Unload to Unicode format	Example 18 — Unloading a table space and loading data as Unicode
Unload selected columns	Example 2 — Unloading columns in clustering order Example 4 — Unloading while allowing read write access to the table space Example 8 — Using multiple SELECT statements Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 15 — Unloading LOB and XML data; using nonstandard null indicators
Unload selected partitions	Example 5 — Unloading data from a DSN1COPY Example 6 — Unloading a full image copy Example 10 — Unloading from incremental image copies
Unload selected rows	Example 4 — Unloading while allowing read write access to the table space Example 5 — Unloading data from a DSN1COPY Example 6 — Unloading a full image copy Example 7 — Using FILTERPART Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 14 — Handling an abnormal termination
Use a subselect to unload selected rows	Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism
Use a join to unload selected rows	Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism
Use columnar functions during unload	Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism
Unload using DB2 dynamic SQL	Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 14 — Handling an abnormal termination Example 15 — Unloading LOB and XML data; using nonstandard null indicators
Handle an abnormal termination	Example 14 — Handling an abnormal termination
Specify a nonstandard null indicator	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
Unload zoned decimal data	Example 17 — Changing overpunch values in zoned decimal data
Use high-speed data migration with LOADPLUS	Example 19 — Unloading data to LOADPLUS
Unload XML data	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
Unload LOB data	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
Write to referenced files	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
Object types
Nonpartitioned table space	Example 3 — Unloading multiple tables to a single data set Example 8 — Using multiple SELECT statements Example 9 — Unloading from multiple table spaces Example 11 — Using a DDLIN data set Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 14 — Handling an abnormal termination Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 17 — Changing overpunch values in zoned decimal data Example 18 — Unloading a table space and loading data as Unicode
Partitioned table space	Example 1 — Unloading partitions to separate data sets Example 2 — Unloading columns in clustering order Example 4 — Unloading while allowing read write access to the table space Example 5 — Unloading data from a DSN1COPY Example 6 — Unloading a full image copy Example 7 — Using FILTERPART Example 9 — Unloading from multiple table spaces Example 10 — Unloading from incremental image copies Example 12 — Unloading to CSV format Example 16 — Using dynamic allocation Example 19 — Unloading data to LOADPLUS
DSN1COPY	Example 5 — Unloading data from a DSN1COPY
Full image copy	Example 6 — Unloading a full image copy
Incremental image copy	Example 10 — Unloading from incremental image copies
Command options
ACTIVE NO	Example 10 — Unloading from incremental image copies Example 12 — Unloading to CSV format Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 14 — Handling an abnormal termination Example 17 — Changing overpunch values in zoned decimal data Example 18 — Unloading a table space and loading data as Unicode
ACTIVE YES	Example 16 — Using dynamic allocation
ANALYZE DB2STATS	Example 16 — Using dynamic allocation
AUTOTAG	Example 18 — Unloading a table space and loading data as Unicode
CNTLCARDS	Example 3 — Unloading multiple tables to a single data set Example 5 — Unloading data from a DSN1COPY Example 7 — Using FILTERPART Example 8 — Using multiple SELECT statements Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 17 — Changing overpunch values in zoned decimal data Example 18 — Unloading a table space and loading data as Unicode Example 19 — Unloading data to LOADPLUS
CNTLDDN	Example 8 — Using multiple SELECT statements
CONSISTENT YES	Example 4 — Unloading while allowing read write access to the table space
CURRENTDEGREE	Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism
DATEFMT	Example 6 — Unloading a full image copy
DELETEFILES	Example 14 — Handling an abnormal termination
DIR	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
DIRECT NO	Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 14 — Handling an abnormal termination Example 15 — Unloading LOB and XML data; using nonstandard null indicators
DIRECT YES	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
DSNAME	Example 7 — Using FILTERPART Example 9 — Unloading from multiple table spaces Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 16 — Using dynamic allocation Example 19 — Unloading data to LOADPLUS
DSNTYPE	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
ENUMROWS	Example 9 — Unloading from multiple table spaces
ESTROWS	Example 7 — Using FILTERPART
FILTERPART	Example 7 — Using FILTERPART
FORMAT	Example 12 — Unloading to CSV format Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 17 — Changing overpunch values in zoned decimal data Example 19 — Unloading data to LOADPLUS
FIXEDVARCHAR	Example 2 — Unloading columns in clustering order Example 17 — Changing overpunch values in zoned decimal data
IF NULL VALUE or IF predicate VALUE	Example 2 — Unloading columns in clustering order
IMAGECOPY	Example 6 — Unloading a full image copy Example 10 — Unloading from incremental image copies
INCREMENTAL	Example 10 — Unloading from incremental image copies
INFILE	Example 5 — Unloading data from a DSN1COPY Example 6 — Unloading a full image copy Example 10 — Unloading from incremental image copies Example 11 — Using a DDLIN data set
INTERVAL	Example 4 — Unloading while allowing read write access to the table space
INTO	Example 1 — Unloading partitions to separate data sets Example 2 — Unloading columns in clustering order Example 3 — Unloading multiple tables to a single data set Example 8 — Using multiple SELECT statements Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 16 — Using dynamic allocation Example 17 — Changing overpunch values in zoned decimal data Example 19 — Unloading data to LOADPLUS
LIMIT	Example 2 — Unloading columns in clustering order Example 4 — Unloading while allowing read write access to the table space
NULLCHAR	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
NULLTYPE	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
OBID	Example 5 — Unloading data from a DSN1COPY Example 11 — Using a DDLIN data set
ON FAILURE	Example 14 — Handling an abnormal termination
ORDER YES	Example 2 — Unloading columns in clustering order Example 3 — Unloading multiple tables to a single data set Example 19 — Unloading data to LOADPLUS
ORDER BY	Example 6 — Unloading a full image copy Example 9 — Unloading from multiple table spaces
OUTPUT	Example 7 — Using FILTERPART Example 9 — Unloading from multiple table spaces Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 16 — Using dynamic allocation Example 19 — Unloading data to LOADPLUS
PART	Example 5 — Unloading data from a DSN1COPY Example 6 — Unloading a full image copy Example 10 — Unloading from incremental image copies
RECORDID	Example 8 — Using multiple SELECT statements
RETCODE	Example 14 — Handling an abnormal termination
SELECT	All examples except 18
SHRLEVEL CHANGE	Example 4 — Unloading while allowing read write access to the table space
SORTDEVT	Example 3 — Unloading multiple tables to a single data set
SPACE	Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 16 — Using dynamic allocation Example 19 — Unloading data to LOADPLUS
SUBSETS	Example 15 — Unloading LOB and XML data; using nonstandard null indicators
TABLESPACE	Example 18 — Unloading a table space and loading data as Unicode
TSFMT	Example 6 — Unloading a full image copy
UNLOADDN	Example 8 — Using multiple SELECT statements Example 10 — Unloading from incremental image copies Example 12 — Unloading to CSV format Example 13 — Using Db2 dynamic SQL (DIRECT NO) and Db2 parallelism Example 14 — Handling an abnormal termination Example 16 — Using dynamic allocation Example 17 — Changing overpunch values in zoned decimal data Example 18 — Unloading a table space and loading data as Unicode
UNICODE	Example 18 — Unloading a table space and loading data as Unicode
UNIT	Example 15 — Unloading LOB and XML data; using nonstandard null indicators Example 16 — Using dynamic allocation Example 19 — Unloading data to LOADPLUS
WHERE clause	Example 4 — Unloading while allowing read write access to the table space Example 5 — Unloading data from a DSN1COPY Example 6 — Unloading a full image copy Example 7 — Using FILTERPART Example 14 — Handling an abnormal termination
XBMID	Example 4 — Unloading while allowing read write access to the table space
ZONEDDECOVP	Example 17 — Changing overpunch values in zoned decimal data

The following topics present several examples of jobs for the UNLOAD PLUS product:

Examples of UNLOAD PLUS jobs

On this page