Skip to Content
Information
Limited support BMC 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.

ROWID

ROWID defines a field that contains generated row IDs.

This field must be in internal format (a varying length hexadecimal string). The first two bytes of this hexadecimal string contain the length of the row ID string. The length is the number of bytes and does not include the two length bytes.

The following information describes how LOADPLUS processes ROWID fields:

  • With the exception described in the restrictions, if the ROWID field is defined as GENERATED ALWAYS, LOADPLUS ignores the VALUE option in the field specification and generates its own unique row identifiers.
  • If the ROWID field is defined as GENERATED BY DEFAULT, LOADPLUS performs minimal validation on the ROWID field and loads the ROWID data with no conversions.

Restrictions

ROWID fields in LOADPLUS have the following restrictions:

  • You cannot reference a ROWID field in a WHEN, DEFAULTIF, or NULLIF clause.
  • You cannot specify DEFAULTIF with VALUE or NULLIF for a ROWID field.
  • If the ROWID field is defined as GENERATED ALWAYS and you specify FORMAT BMCLOAD, LOADPLUS discards all rows for the table and issues message BMC51590E.
Warning

Important

If you are using LOADPLUS in a Change Manager worklist environment, for more information about loading ROWID columns, see the BMC AMI Change Manager documentation

Related topic

Data-type-keywords

 

 

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

LOADPLUS for DB2 11.2