REPLACE (INTO TABLE option)

Specify REPLACE on the INTO TABLE statement to reset the specified partitions to empty before loading any data.


Related topics

INTO-TABLE-options

BMC-AMI-Load-Syntax-diagrams

REPLACE 

RESUME.png

You can use REPLACE and RESUME YES in a single BMC AMI Load step by specifying multiple INTO TABLE statements. For an example, see Replacing-some-partitions-adding-data-to-some-partitions-and-leaving-remaining-partitions-available.

If you specify LOAD RESUME YES SHRLEVEL CHANGE and a mix of PART REPLACE and PART RESUME YES, BMC AMI Load stops the RESUME YES partitions during the load.

 

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