Loading data with 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

   We recommend 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.