PERIODOVERRIDE (INTO TABLE option)


This option allows columns defined as ROW-BEGIN or ROW-END GENERATED ALWAYS to be specified in the field specification list and loading them into the specified table.

Although this keyword is specified at the table level, it applies to all INTO table specifications.

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.

However, processing for the deprecated keywords will be ignored under SQL INSERT mode:

LOAD RESUME SHRLEVEL CHANGE


 

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

BMC AMI Load for Db2 13.1