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.

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 that 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	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

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

Related topics

Running UNLOAD PLUS jobs

Tuning UNLOAD PLUS jobs

Building the UNLOAD PLUS job

Examples of UNLOAD PLUS jobs

Comments