Skip to Content

AUTOTAG

Specify the AUTOTAG option to tell UNLOAD PLUS whether to add a four-byte character constant value at the beginning of each output record and to generate appropriate load control statements.

Related topic

Basic processing options

AUTOTAG.png

When you specify CNTLCARDS BMCLOAD and the following conditions exist, specify AUTOTAG YES:

  • You are using a single SYSCNTL data set.
  • You specify multiple SELECT statements on tables that are in the same table space.
Warning

Important

You cannot specify AUTOTAG YES if you also specify FORMAT BMCLOAD.

NO

AUTOTAG NO is the default. If you specify AUTOTAG NO, UNLOAD PLUS does not add a value to the beginning of each output record for each SELECT statement. When generating load control statements, UNLOAD PLUS generates syntax for multiple LOAD statements, generating one LOAD for each SELECT statement.

YES

If you specify AUTOTAG YES, UNLOAD PLUS adds a four-byte value to the beginning of each output record for each SELECT statement, and increments the value for each successive SELECT statement. For example, the value for the first SELECT statement is 0001; the value of a second SELECT statement would be 0002.

When generating load control statements, UNLOAD PLUS

  • Generates syntax for one LOAD statement with multiple INTO clauses, generating one INTO clause for each SELECT statement
  • Generates appropriate WHEN syntax

Restrictions

The following restrictions apply to the AUTOTAG YES option:

  • If you also specify FORMAT BMCLOAD, UNLOAD PLUS terminates.
  • If you specify either of the following options, UNLOAD PLUS ignores the AUTOTAG option:
    • FORMAT XML
    • RECORDID

 

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

UNLOAD PLUS for DB2 13.1