Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

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 BMC AMI Unload for Db2 13.1.

Overriding the OBID value

BMC AMI Unload enables you to override the OBID value defined by IBM Db2 when qualifying rows for unloading.

By default, BMC AMI Unload uses the value that Db2 assigns. This makes it easier to recover data if a table is dropped and you need to unload from a copy of the table space. You can override the OBID specification that BMC AMI Unload retrieves from the Db2 catalog. This enables you, for example, to unload data from image copies or DSN1COPYs after a table has been dropped.

If you use an OBID value of 0, BMC AMI Unload ignores all OBIDs in the input records. Use the value of 0 for single-table table spaces only. Using a value of 0 with a multi-table table space might produce unpredictable results or result in an abend.

To override the Db2-defined OBID value

  1. Code the OBID keyword in the unload statement.

    Important

    • If you are using the UNLOAD command, you specify OBID on the FROM TABLE clause.
    • For the UNLD command, you must supply the OBID value as an integer. For the UNLOAD command, you can supply the value either as an integer or in hexadecimal format.
    • BMC AMI Unload does not perform range validation of the supplied OBID.
  2. If you are using the UNLOAD command, specify the INFILE option.
  3. Ensure that the table name in the FROM TABLE clause in the unload statement exists. It need not contain rows, because BMC AMI Unload needs only the column specification for the table.
  4. Ensure that, for the table in the FROM TABLE clause, the columns that BMC AMI Unload unloads are compatible with the table in the input copy data set.
  5. If the table in the copy has an EDITPROC, ensure that the Db2-defined table is defined with that same EDITPROC.

Related topics

OBID
FROM  



 

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