Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

Loading data with FORMAT BMCUNLOAD

Use this procedure to load data that was unloaded by using the FORMAT BMCLOAD option of UNLOAD PLUS.

For an example that shows you how to use this feature, see Example 14 — LOAD REPLACE from UNLOAD PLUS data in internal format.

Before you begin

Review Table structure considerations for FORMAT BMCUNLOAD.

To load data with FORMAT BMCUNLOAD

  1. Ensure that the table that you are loading meets the requirements specified in Table structure considerations for FORMAT BMCUNLOAD.
  2. Specify FORMAT BMCUNLOAD with your LOAD command.

  3. Include a WHEN TABLE=obid clause with your INTO option.For more information about this option, see WHEN.

    Warning

    BMC recommends that you specify input files from a single UNLOAD PLUS step in a single LOADPLUS step. Otherwise, you might encounter data corruption or other unpredictable results.

  4. Specify IDENTITYOVERRIDE YES when both of the following conditions exist:
    • You are loading an identity column that is defined as GENERATED ALWAYS.
    • You did not already include IDENTITYOVERRIDE YES as a string in your UNLOAD PLUS CNTLCARDS BMCLOAD option.
  5. Specify PERIODOVERRIDE and TRANSIDOVERRIDE on your INTO option when both of the following conditions exist:
    • You are loading a system-period temporal table
    • You did not already include PERIODOVERRIDE and TRANSIDOVERRIDE as a string on the INTO option in UNLOAD PLUS.
  6. If you are loading a system-period temporal table, add the appropriate field specifications for the temporal-specific field.

  7. If you do not use the LOAD control statements that UNLOAD PLUS generated, ensure that your LOAD command does not contain field specifications or any of the incompatible command options that are described in Command options that are incompatible with FORMAT BMCUNLOAD.

    Important

    When you use this feature, we strongly recommend that you use the LOAD control statements that UNLOAD PLUS generates. Using these control statements ensures that your command options comply with the requirements for using this feature.

Related topics

Data-and-control-cards-from-UNLOAD-PLUS

Using-data-from-UNLOAD-PLUS-in-internal-BMC-format

Building-and-running-load-jobs

 

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