Default language.

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 Load for Db2 13.1.

ROWID columns

BMC AMI Load

 supports ROWID columns.

BMC AMI Load generates ROWID values unless they are provided in the input data. The following example shows a ROWID column specification:

Example
LOAD DATA INDDN SYSREC LOG NO REPLACE
 INTO TABLE NGT.LOB_TABLE
 ( 'COL01             ' POSITION(3:6)       INTEGER
 , 'COL02             ' POSITION(7:15)      CHAR(9)
 , 'COL03             ' POSITION(17:17)     CHAR(1)
                          NULLIF(16)=X'FF'
 , 'COL04             ' POSITION(19:19)     CHAR(1)
                          NULLIF(18)=X'FF'
 , 'ROWIDCOL          ' POSITION(20:42)     ROWID
 )

How BMC AMI Load loads ROWID values

When loading ROWID columns that are defined as NOT NULL GENERATED ALWAYS, BMC AMI Load generates ROWIDs. The LOAD statement column specification for the table must not reference the ROWID columns. If the column specification references the ROWID columns, BMC AMI Load issues an error message and the load fails.

BMC AMI Load also supports ROWID columns that are defined as NOT NULL GENERATED BY DEFAULT. The input load data may or may not contain values for these columns. If the input data does not contain ROWID values, the column specification must not reference the ROWID column and BMC AMI Load generates ROWID values when loading. If the input data does contain ROWID values, the column specification must reference the ROWID column and BMC AMI Load loads the ROWID values from the input data.

Data in UNLOAD format

When you load UNLOAD format data, the ROWID value must exist in the input data. BMC AMI Load loads the ROWID values from the input data when the column is defined as NOT NULL GENERATED BY DEFAULT. BMC AMI Load does not generate new ROWID values when loading data in UNLOAD format.

If the ROWID column is defined as NOT NULL GENERATED ALWAYS, BMC AMI Load does not support the loading of UNLOAD format data. In this case, BMC AMI Load issues an error message and the load fails.

Related topics

ROWID

Operational-considerations-for-BMC-AMI-Load

 


 

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