OBID(integer)

Use the OBID(integer) option to specify the OBID of the table that you are loading.

Important

Parentheses are optional for this keyword.


Related topics

Basic-options

BMC-AMI-Load-Syntax-diagrams

OBID-integer-INTO-TABLE-option 

OBID.png

This option overrides the row selection process used when loading rows using FORMAT UNLOAD. Specify a valid OBID value in decimal format. The following considerations apply to the OBID option:

  • If you do not specify this option, the input data OBID must match the OBID of the table that you are loading.
  • BMC AMI Load discards any input rows that do not match.
  • If you specify OBID(0), BMC AMI Load does not perform OBID checking and all input rows are processed.
Warning

Be careful when you use the OBID keyword. If you specify a bad value or have not performed OBID checking, Db2 might abend.

Alternate OBID processing

BMC AMI Load supports an override of the defined OBID when loading from a FORMAT(UNLOAD) input file.

When you use FORMAT(UNLOAD), BMC AMI Load compares the Db2-defined OBID with the OBID of each input row. If the OBIDs do not match, the row is not processed. If you specify the OBID keyword in the LOAD DATA statement, BMC AMI Load compares the specified OBID value with the input row OBID and selects only matching rows for processing. BMC AMI Load ignores rows whose OBIDs do not match.

To turn off OBID checking, code the OBID keyword with a value of 0. This forces BMC AMI Load to load all input rows to a table from a Db2 system different from the one unloaded, or to load from an unload file that was created before a table was dropped and recreated.


 

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