Skip to Content

Default language.

UNLD BYPART

Related topics

UNLD syntax option descriptions

UNLD syntax diagrams

PARTS or LPARTS

BYPART

BYPART tells BMC AMI Unload to unload individually to separate files the partitions that you specify with the PARTS option. If you do not specify the PARTS option with BYPART, BMC AMI Unload unloads the total number of partitions in the table space individually to separate files.

The BYPART option applies only when the target table to be unloaded is partitioned and dynamic allocation is in use. If not, BMC AMI Unload ignores this option.

You cannot use the BYPART option in combination with the following options:

  • COPYDDN
  • COPYDSN
  • SYSCOPY
  • MODE(AUTO)
  • MODE(DB2SQL)
Information
Example

The following statement:

UNLD BYPART PARTS 1,5:7,20 FROM TABLE TABLE1

achieves the same effect as the following statement:

UNLD PARTS  1   FROM TABLE TABLE1
UNLD PARTS  5   FROM TABLE TABLE1
UNLD PARTS  6   FROM TABLE TABLE1
UNLD PARTS  7   FROM TABLE TABLE1   
UNLD PARTS  20  FROM TABLE TABLE1

However, if the original UNLD BYPART option uses a WHERE clause that causes certain parts to be filtered, BMC AMI Unload individually unloads only the applicable parts. 

 

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

BMC AMI Unload for Db2 13.1