Skip to Content

Default language.

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

OVERRIDE

BMC AMI Load uses this option to allow columns defined as GENERATED ALWAYS to be specified in the field specification list. The columns data will be loaded from SYSREC instead of being dynamically generated.

image2022-12-19_11-15-54.png

OVERRIDE does not allow all GENERATED ALWAYS column types. The following keywords for OVERRIDE specify the types that can be overridden:

SYSTEMPERIOD

BMC AMI Load allows the columns defined as ROW-BEGIN or ROW-END GENERATED ALWAYS to be overridden.

TRANSID

BMC AMI Load allows the column defined as TRANSACTION-START-ID GENERATED ALWAYS to be overridden.

NONDETERMINISTIC

BMC AMI Load allows the column defined as DATA-CHANGE-OPERATION GENERATED ALWAYS to be overridden.

IDENTITY

BMC AMI Load allows the column defined as IDENTITY GENERATED ALWAYS to be overridden.

BMC AMI Load allows data to be loaded into a row change timestamp column that is defined as GENERATED ALWAYS. In INSERT mode, a generated always ROWCHANGE timestamp column can’t be loaded, i.e. when SHRLEVEL CHANGE RESUME YES is in effect. 

Specify OVERRIDE(ROWCHANGE) when loading a table natively with data that was previously unloaded to preserve the timestamps. This rule applies when you  load data through FORMAT UNLOAD.   

Warning

Important

Regardless of the OVERRIDE(ROWCHANGE) specification, if NULLIF or DEFAULTIF is specified for the GENERATED ALWAYS ROWCHANGE TIMESTAMP (RCT) column in the field specification clause, it results in an error Message NGTL150E. 

Warning

Important

  • The parenthesis are optional.
  • If you specify multiple OVERRIDE keywords, a comma is required between each option.


Information
Example
OVERRIDE(SYSTEMPERIOD, IDENTITY)

Will allow the row-begin, row-end, and identity type columns to be overridden.

Warning

Important

IBM has deprecated the PERIODOVERRIDE, TRANSIDOVERRIDE and IDENTITYOVERRIDE keywords and introduced the OVERRIDE keyword to group all of the OVERRIDEs. BMC AMI Load supports both formats and allows for the specification of both formats under the same command.

All overrides are restricted under SQL INSERT MODE, that is they are not allowed, and will result in an error.


Related topics

Basic-options

Syntax-diagrams-for-BMC-AMI-Load

 

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

BMC AMI Load for Db2 12.1