Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Examples of UNLOAD PLUS jobs

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

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.


Cross-reference of examples by function

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-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-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-15, 17, 18

Partitioned table space

1, 2, 4-7, 9, 10, 12, 16, 19

DSN1COPY

5

Full image copy

6

Incremental image copy

10

Command options

ACTIVE NO

10, 12-14, 17, 18

ACTIVE YES

16

ANALYZE DB2STATS

16

AUTOTAG

18

CNTLCARDS

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

CNTLDDN

8

CONSISTENT YES

4

CURRENTDEGREE

13

DATEFMT

6

DELETEFILES

14

DIR

15

DIRECT NO

13-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-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-14, 16-18

UNICODE

18

UNIT

15, 16, 19

WHERE clause

4-7, 14

XBMID

4

ZONEDDECOVP

17

Was this page helpful? Yes No Submitting... Thank you

Comments